We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

  • About
  • Contact
  • Careers
  • 337-984-4345
Guidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real Estate
  • 337-984-4345
  • Home
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Inherited Land
  • Who’s Your REALTOR®?
  • Success Coaching
  • Blog
  • Reviews

$230,000
42787 SCARLETT Circle
Hammond, LA 70403
MLS# NO2573026
3 beds  |  2 baths  |  2480 sqft


Photo 1
  1 / 23  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23

Property Description
Welcome home to this 3-bedroom, 2-bathroom home, conveniently located in Tara Court with easy access to I-12! Thoughtfully designed with both style and comfort in mind, this home features crown molding, granite countertops, scored and stained concrete floors, and 9-10-foot ceilings throughout. The spacious primary suite offers a relaxing retreat with his-and-her closets, dual vanity sinks, a Jacuzzi tub, and a separate shower. For added peace of mind, the home is equipped with Vivint security system. Outdoor living and entertaining are a breeze with a 12x24 screened patio, a 7x24 covered patio, and a fully fenced backyard featuring a 6-foot cedar privacy fence. The backyard also includes a convenient 12x12 storage shed, providing plenty of room for tools, equipment, and extra storage. Located in the desirable Ponchatoula school district, this home offers the perfect combination of convenience, comfort, and outdoor living. Don't miss the opportunity to make this one your own!

Details
Documents
Listing Info
Status: Active
Listing Date: 2026-08-18
Delayed Marketing: No
Listing Price: 230000
Current Price: $230,000
List Price/SqFt: 144.93
Type: Single Family Residence
Document Modified: 2026-08-18 11:12:51.256266
Modification Timestamp: 2026-09-09T01:36:46Z
Photo Modified: 2026-08-18T16:07:41Z
General Property Description
# Bedrooms: 3
Baths - Full: 2
Total Baths: 2
SqFt - Living: 1587
SqFt - Total: 2480
SqFt - Source: Measured
Stories: 1
Year Built: 2010
Acres: 0.22
Acreage Range: 0 - 0.5
Lot Dimensions: 80x120
Pool on Subject Property: No
Originating Details
Originating System ID: ROAMM
Originating System Key: 59465821
Originating System Listing ID: 2573026
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 42787
Street Name: SCARLETT Circle
Parish: Tangipahoa
State: LA
Zip Code: 70403
Subdivision: Tara Court
Tax Assessment Number: 6311547
Directions: FROM I-12 TAKE THE PUMPKIN CENTER EXIT, HEAD S ON PUMPKIN CENTER RD, TAKE LEFT ON GENERAL OTT, TARA COURT ON LEFT Bounding Streets: GENERAL OTT
Property Features
Style: Traditional
Siding: Stucco; Vinyl Siding
Parking: Attached
Construction: Brick
Foundation: Slab
Roof: Composition
Interior: Attic Access
Heating: Central
Cooling: Central Air
Appliances: Dishwasher; Disposal; Microwave
Countertops: Granite
Rooms: Bedroom 1; Dining Room; Kitchen; Living Room; Primary Bathroom; Primary Bedroom; Bedroom 2
Fencing: Wood; Other
Patio: Covered
Other Structures: Workshop
Utilities: Elec: Entergy
Room Information
Room Name Length Width Remarks
Bedroom 111.0011.00Bedroom
Primary Bathroom11.0015.50Primary Bathroom
Primary Bedroom14.0015.50Primary Bedroom
Bedroom 211.0012.00Bedroom
Dining Room11.0011.00Dining Room
Living Room18.0014.00Living Room
Kitchen11.0014.00Kitchen
Listing Documents
View Document PDD, WOW, Flood Dis, Dual Agent

IDX
Listing Office: Monument Real Estate, LLC

Last Updated: September - 09 - 2026

The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial 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.


Search powered by FBS Products

Find Us

Get Directions
 

1232-A Camellia Blvd.
Lafayette, LA 70508
P: 337-984-4345

 

AGENT ON CALL | 337-446-6053

 

CALL US: 337-984-4345

 

GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for IDX. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.

Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.

  • Home
  • 337-984-4345
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Looking to Buy?
    • Inherited Real Estate?
    • Choose Your REALTOR®
  • Blog
  • Success Coaching
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate
Thank you for visiting Guidry & Co. Real Estate, for more information please register here:

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

 

Return To Homepage