• 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.

$3,200
For Rent

279 Collins View Court

Lawrenceville, GA 30043
5 beds | 3 baths | 0.16 acres | #7696838
  • Save
  • Contact
  • Share
  • Price Change Alerts
74 photos
Type:Rental
Structure:House
Zone:Residential

Description

The most Gorgeous home in Collins Hill High School District, truly an updates galore. Its the most serene property sitting on a spectacular lot with a very large daylight basement to create a PERFECT 10! Open & bright floor plan freshly painted in modern colors. THIS HOME HAS THE LARGEST SQUARE FOOTAGE ON UPPER TWO LEVELS. Welcome to this palatial looking free standing single family home with 3,542 sq ft on upper two levels. New Paint, New Carpet, New Refrigerator, New Water Heater, One new HVAC Condenser. Surprisingly large floor plan in one of the most desirable school district. Spacious 5 BR/3BA brick front home with relaxing covered front porch, huge back deck and large backyard and large basement. The welcoming 2 story entrance foyer with decorative Chandelier, leads you to a Formal Living Room with French doors which can be used as Bedroom with adjacent full bathroom. Next you will find a spacious Dining Room with trey ceiling and custom moldings. Adjacent to the Dining room is the Large eat in kitchen with gourmet appliances, New Maytag Double Door Refrigerator, Granite Counter Tops, large kitchen island which also serves as a Breakfast table. From the kitchen, you can access the outdoor deck, which overlooks a private and level backyard. The kitchen seamlessly opens to a fireside family room perfect for gatherings and relaxation. Stairs lead to a large landing area which can serve as a Craft area or sitting area with view of the 2-story entry foyer. The spacious master suite is upstairs. It includes space for a sitting area/office desk/exercise machine. A luxurious master bath with separate Tub and Shower, two vanities, A spacious walk-in closet with separate his and her storage areas and dressing room with full size mirror. Unbelievably large 3 kids' bedrooms with one full bathroom upstairs. Spacious Laundry Room on the main level. Large Deck off Kitchen & Patio off of unfinished terrace level. Terrace level walls have been insulated to provide additional work space or exercise room. Approximately 1,600 sq ft basement area ready to be finished. Large level backyard for your family to enjoy. Excellent location close to schools and walking distance to Rock Springs Park. Roof has been changed 7 years ago.

  • Interior Details
      • InteriorCrown Molding, Double Vanity, Dry Bar, Entrance Foyer 2 Story, High Ceilings 9 ft Main, High Ceilings 9 ft Upper, High Speed Int
      • Fireplaces1
    • Heating & Cooling
      • CoolingCeiling Fan(s), Central Air, Zoned
      • HeatingForced Air, Natural Gas, Zoned
    • Beds & Baths
      • Bathrooms3.0
      • Bedrooms5
      • Full Baths3
      • Bedrooms on Main Level1
  • Property Details
      • Lot FeaturesBack Yard, Front Yard, Landscaped, Level, Rectangular Lot
      • Lot DescriptionBack Yard, Front Yard, Landscaped, Level, Rectangular Lot
      • Exterior FeaturesPrivate Yard, Rear Stairs
      • Exterior MaterialsPrivate Yard, Rear Stairs
      • ViewOther
    • Measurements
      • Acres0.16
    • Parking
      • Parking FeaturesGarage, Garage Faces Front
      • Parking TypeGarage
      • Parking Spaces2
  • Construction Details
      • Basement DescriptionDaylight, Exterior Entry, Full, Unfinished, Walk-Out Access
      • StyleTraditional
      • Property TypeRental
      • Basement1
      • Basement Finished1
    • Condition
      • Year Built2006
    • Material information
      • RoofComposition
  • Utilities / Energy Details
      • Utility FeaturesCable Available, Electricity Available, Natural Gas Available, Phone Available, Sewer Available, Underground Utilities, Water Av
      • AppliancesDishwasher, Disposal, Gas Range, Gas Water Heater, Microwave, Refrigerator
  • Community and Neighborhood Details
      • Community FeaturesHomeowners Assoc, Near Schools, Street Lights
      • SubdivisionCOLLINSWOOD
    • Location
      • Middle SchoolCreekland - Gwinnett
      • CountyGwinnett - GA
      • Elementary SchoolRock Springs
      • High SchoolCollins Hill
  • Financial Details
      • Date AvailableJanuary 01, 2026
      • Original List Price$3,200
  • Other
      • MLS #7696838

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: SEEMA JAIN (#JAINS)
Listing Office: Sugarloaf Realty Partners, LLC. (#SUGR01)

Provident LegacyReal Estate Group
Facebook
Google
OR