• Sign Up
  • Log In
Provident Legacy
CALL NOW
(201) 809-9925admin@providentlegacyrealtors.com
  • Home
  • Search
    • General Search
    • Featured Sales
    • Featured Rentals
    • Home Valuation
    • Community Guides
  • Buying
    • Buying Guide
    • Buy a Home in Hudson County
    • Mortgage Calculator
  • Selling
    • Selling Guide
    • Sell Your Home
  • Get Licensed
  • About
    • Find An Agent
    • Leadership Team
    • Business Partnerships
    • LAD Policies
    • Contact
    • Testimonials
  • Join Us
    • Join Our Team
    • Provident Careers
  • CALL NOW(201) 809-9925
    admin@providentlegacyrealtors.com
    Copy Email
  • Provident Legacy Realtors
    177 Broadway
    Bayonne, NJ 07002
    (201) 809-9925
    admin@providentlegacyrealtors.com
    1220816
  • Provident Legacy Realtors Sugar Hill
    740 N Price Rd
    Sugar Hill, GA 30518
    (470) 797-7400
    admin@providentlegacyrealtors.com
    79174
  • Provident Legacy Realtors Cliffside Park
    607B Anderson Avenue
    Cliffside Park, NJ 07010
    (201) 809-9923
    admin@providentlegacyrealtors.com
    1220816

Company

  • Home
  • Testimonials
  • Contact
  • Get Licensed
  • Find An Agent
  • Leadership Team

Buying

  • Buying Guide
  • Buy a Home in Hudson County
  • Mortgage Calculator

Search

  • Search New Jersey
  • Search Georgia
  • Featured Properties
  • Home Valuation

Selling

  • Sell Your Home
  • Selling Guide

Explore

  • Communities
Provident Legacy - Footer Logo
  • Office Holidays/Closures
  • Fiduciary Responsibilities
  • Privacy
  • Terms
  • DMCA
  • Accessibility
  • Fair Housing
© 2025 Provident Legacy Realtors. All rights reserved.
Website built by CloseHack.
All Jersey MLS

The data relating to real estate for sale on this web-site comes in part from the Internet Listing Display database of the CENTRAL JERSEY MULTIPLE LISTING SYSTEM, INC. Real estate listings held by brokerage firms other than this site-owner are marked with the ILD logo. The CENTRAL JERSEY MULTIPLE LISTING SYSTEM, INC does not warrant the accuracy, quality, reliability, suitability, completeness, usefulness or effectiveness of any information provided. Copyright 2023, CENTRAL JERSEY MULTIPLE LISTING SYSTEM, INC. All rights reserved. The CENTRAL JERSEY MULTIPLE LISTING SYSTEM, INC retains all rights, title and interest in and to its trademarks, service marks and copyrighted material. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify properties the consumer may be interested in purchasing or renting.

First Multiple Listing Service, Inc.

​ Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. © 2022 First Multiple Listing Service, Inc.​

New Jersey Multiple Listing Service, Inc.

The data relating to the real estate for sale on this web site comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than Provident Legacy are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Some properties listed with the participating brokers do not appear on this website at the request of the seller. Listings of brokers that do not participate in Internet Data Exchange do not appear on this website. 

All information deemed reliable but not guaranteed. Last date updated: 01/09/2023

2023 New Jersey Multiple Listing Service, Inc. All rights reserved.  

Garden State Multiple Listing Service

The data relating to real estate for sale on this website comes in part from the IDX Program of Garden
State Multiple Listing Service, L.L.C. Real estate listings held by other brokerage firms are marked as
IDX Listing. Information deemed reliable but not guaranteed. The dissemination of listings on this website does not constitute the consent required by N.J.A.C. 11:5.6.1 (n) for the advertisement of listings exclusively for sale by another broker. Any such consent must be obtained in writing from the listing broker.

Copyright © 2023 Garden State Multiple Listing Service, L.L.C. All rights reserved.

Georgia MLS

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of GAMLS. All real estate listings are marked with the GAMLS Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers. The broker providing these data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision. Copyright 2023 GAMLS. All rights reserved.

Monmouth Ocean Regional MLS

© Monmouth Ocean Regional MLS. All rights reserved. Information Deemed Reliable, but Not Guaranteed. Listing information is from various brokers who participate in IDX and not all listings may be visible on the site. The property information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Hudson Multiple Listing Service

IDX information for Hudson Multiple Listing Service is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.

South Jersey Shore Regional MLS

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

$6,900
For Rent

870 Longstone Landing

Alpharetta, GA 30022
6 beds | 5 baths | 0.62 acres | #7696093
  • Save
  • Contact
  • Share
  • Price Change Alerts
82 photos
Type:Rental
Structure:House
Zone:Residential

Description

Welcome to your dream home! This RARE and exceptional property is located in the highly desired swim/tennis Glen Abbey subdivision, offering one of the BEST and LARGEST lake lots in the community. This elegant 4-sided brick home features a grand two-story foyer and an open, light-filled floor plan with 18 windows on the main level overlooking the serene lake. The expanded deck, now double its original size, provides the perfect setting for entertaining with gorgeous lake views. Inside, the home showcases refreshed and refinished flooring throughout, adding a polished touch to every room. Enjoy the spacious dining room that easily seats 12+, ideal for hosting. The NEWLY REMODELED KITCHEN features an electric cooktop, double oven, BRAND NEW QUARTZ countertops, and abundant cabinetry. A cozy family room with a fireplace sits just off the kitchen, while two additional fireplaces enhance the living room and the master bedroom. All bathrooms have been updated or fully renovated, including the luxurious master bath with quartz countertops, double vanity, separate tub, frameless shower, and a large walk-in closet. A convenient bedroom and full bath on the main level complement the four bedrooms upstairs. The finished basement includes a bedroom, full bathroom, billiard room, and flexible spaces perfect for a gym or lounge, along with generous storage. The home sits on a professionally landscaped, level cul-de-sac lot and includes a 3-car garage. Glen Abbey amenities include 8 tennis courts, a pool, playground, pavilion, and a walking trail connecting to the Big Creek Greenway. All within minutes of top schools, Avalon, Downtown Alpharetta, GA 400, and more. Don’t miss this stunning lakefront home that truly has it all!

  • Interior Details
      • InteriorEntrance Foyer, Entrance Foyer 2 Story, High Ceilings 10 ft Main, Vaulted Ceiling(s), Walk-In Closet(s)
      • Fireplaces3
    • Heating & Cooling
      • CoolingCeiling Fan(s), Central Air
      • HeatingCentral
    • Beds & Baths
      • Bathrooms5.0
      • Bedrooms6
      • Full Baths5
      • Bedrooms on Main Level1
  • Property Details
      • Lot FeaturesBack Yard, Lake On Lot
      • Lot DescriptionBack Yard, Lake On Lot
      • Exterior FeaturesOther
      • Exterior MaterialsOther
      • ViewLake
    • Measurements
      • Acres0.62
    • Parking
      • Parking FeaturesDriveway, Garage
      • Parking TypeDriveway
      • Parking Spaces3
  • Construction Details
      • Basement DescriptionExterior Entry, Finished Bath, Interior Entry
      • StyleTraditional
      • Property TypeRental
      • Basement1
      • Basement Finished1
    • Condition
      • Year Built2000
    • Material information
      • RoofComposition
  • Utilities / Energy Details
      • Utility FeaturesCable Available, Phone Available, Sewer Available, Water Available
      • AppliancesDishwasher, Disposal, Electric Cooktop
  • Community and Neighborhood Details
      • Community FeaturesClubhouse, Fitness Center, Homeowners Assoc, Lake, Near Trails/Greenway, Pickleball, Playground, Pool, Sidewalks, Street Lights,
      • SubdivisionGlen Abbey
    • Location
      • Elementary SchoolNew Prospect
      • Middle SchoolWebb Bridge
      • CountyFulton - GA
      • High SchoolAlpharetta
  • Financial Details
      • Date AvailableDecember 28, 2025
      • Original List Price$6,900
  • Other
      • MLS #7696093

Location

Legal

​ Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. © 2022 First Multiple Listing Service, Inc.​

Last Updated: 09/17/2025 8:18 AM. Source: FMLS

Provided By
Listing Agent: NATHALIE APTEKER (#APTEKER)
Listing Office: HomeSmart (#PALM01)

Provident LegacyReal Estate Group
Facebook
Google
OR