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
    • Professional Development
  • Who’s Your REALTOR®?
  • Blog
  • Reviews

Agent on Call

Jennifer Guidry, REALTOR® Sales Associate
337-349-8076


$2,250,000
10175 CORE CEMETERY Road
Folsom, LA 70437
MLS# NO2511510
2 beds  |  2.1 baths  |  3950 sqft


Photo 1
  1 / 60  
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 Photo 24 Photo 25 Photo 26 Photo 27 Photo 28 Photo 29 Photo 30 Photo 31 Photo 32 Photo 33 Photo 34 Photo 35 Photo 36 Photo 37 Photo 38 Photo 39 Photo 40 Photo 41 Photo 42 Photo 43 Photo 44 Photo 45 Photo 46 Photo 47 Photo 48 Photo 49 Photo 50 Photo 51 Photo 52 Photo 53 Photo 54 Photo 55 Photo 56 Photo 57 Photo 58 Photo 59 Photo 60

Property Description
4 Homes Total on 40+ acres! A rare and remarkable opportunity to own a fully custom estate in Folsom featuring a breathtaking main residence, a second, fully renovated home used as a B&B, plus two additional income producing or guest homes - all nestled on approx. 40 acres with river access. A French limestone fountain, over 100 Crepe Myrtle trees, and impeccable landscaping enhance the entrance to this one-of-a-kind main home. The main residence features custom architecture and craftsmanship with reclaimed materials throughout. The open-concept design features handmade doors, antique wood beams from a historic mill, reclaimed Chicago brick accents, and walls of windows that bathe the home in natural light. Enjoy a French limestone fireplace, sound and alarm systems, linen shades from Belgium, and gas lanterns for a warm ambiance. The Gourmet Kitchen in the main home is a dream with flamed granite countertops, premium Wolfe appliances, Northland built-in refrigerators, large pantry, wine cooler, ice maker, and custom cypress cabinetry. The primary suite is a quiet retreat with Bird's Eye Maple cabinets, limestone bath with jacuzzi, steam shower, sitting area with a view of the lovely property; and custom shutters. Even the guest room/second bedroom is custom with white marble finishes and designer mirrors. A whole-home generator is also included for the main house. The B&B Guest Home has been fully renovated, 3BR/2BA with wood flooring, full kitchen, large living room, and covered front/rear porches. Features custom storage, blinds, and functional upgrades. The guest home (next to B&B) adds additional space or rental income with 1BR/1BA, no carpet, full kitchen, cozy living space, and covered porch with car storage. A fourth home on the property, also used as a rental, is 1BR + Loft/1BA with tile floors, full kitchen, and deck with scenic views of the property. Floor plans in attachments of all properties. Living area listed is main house ONLY.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 657.32
Document Modified: 2025-10-29 15:22:13.596486
Status: Active
Listing Date: 2025-09-17
Listing Price: 2250000
Current Price: $2,250,000
Type: Single Family Residence
Modification Timestamp: 2026-01-12T18:36:48Z
Photo Modified: 2025-09-17T17:53:31Z
Location, Tax & Legal Info
Legal Desc: 40.46 ACS SEC 30 5 10
General Property Description
Lot Dimensions: 1755x281x1619x1944
Stories: 1
SqFt - Living: 3423
SqFt - Source: Measured
SqFt - Total: 3950
Acreage Range: 30 - 49.99
Pool on Subject Property: No
# Bedrooms: 2
Baths - Full: 2
Baths - 1/2: 1
Total Baths: 2.1
Year Built: 2005
Acres: 40.46
Remarks & Misc
Remarks: 4 Homes Total on 40+ acres! A rare and remarkable opportunity to own a fully custom estate in Folsom featuring a breathtaking main residence, a second, fully renovated home used as a B&B, plus two additional income producing or guest homes - all nestled on approx. 40 acres with river access. A French limestone fountain, over 100 Crepe Myrtle trees, and impeccable landscaping enhance the entrance to this one-of-a-kind main home. The main residence features custom architecture and craftsmanship with reclaimed materials throughout. The open-concept design features handmade doors, antique wood beams from a historic mill, reclaimed Chicago brick accents, and walls of windows that bathe the home in natural light. Enjoy a French limestone fireplace, sound and alarm systems, linen shades from Belgium, and gas lanterns for a warm ambiance. The Gourmet Kitchen in the main home is a dream with flamed granite countertops, premium Wolfe appliances, Northland built-in refrigerators, large pantry, wine cooler, ice maker, and custom cypress cabinetry. The primary suite is a quiet retreat with Bird's Eye Maple cabinets, limestone bath with jacuzzi, steam shower, sitting area with a view of the lovely property; and custom shutters. Even the guest room/second bedroom is custom with white marble finishes and designer mirrors. A whole-home generator is also included for the main house. The B&B Guest Home has been fully renovated, 3BR/2BA with wood flooring, full kitchen, large living room, and covered front/rear porches. Features custom storage, blinds, and functional upgrades. The guest home (next to B&B) adds additional space or rental income with 1BR/1BA, no carpet, full kitchen, cozy living space, and covered porch with car storage. A fourth home on the property, also used as a rental, is 1BR + Loft/1BA with tile floors, full kitchen, and deck with scenic views of the property. Floor plans in attachments of all properties. Living area listed is main house ONLY.
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Hardiplank: 1
Parking
Detached: 1
Equipment
Generator: 1
Foundation
Piers: 1
Fireplace
Wood Burning: 1
Roof
Metal: 1
Heating
Central: 1
Cooling
Central Air: 1
Water Source
Well: 1
Utilities
Elec: Wst: 1
Propane: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Dining Room: 1
Family Room: 1
Kitchen: 1
Primary Bedroom: 1
Office: 1
Waterfront
Bayou/River: 1
Amenities
Acreage: 1
Fencing
None: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 51797779
Originating System Listing ID: 2511510
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 10175
Street Name: CORE CEMETERY Road
Parish: St. Tammany
State: LA
Zip Code: 70437
Tax Assessment Number: 65915
Directions: Bounding Streets: A. Thompson Rd and Hwy 1077
Property Features
Style: Traditional
Siding: Hardiplank
Parking: Detached
Foundation: Piers
Roof: Metal
Fireplace: Wood Burning
Heating: Central
Cooling: Central Air
Countertops: Granite
Rooms: Bedroom 1; Dining Room; Family Room; Kitchen; Office; Primary Bedroom
Equipment: Generator
Fencing: None
Amenities: Acreage
Waterfront: Bayou/River
Water Source: Well
Utilities: Elec: Wst; Propane
Room Information
Room Name Length Width Remarks
Office11.0014.00Study
Dining Room15.5010.50Dining Room
Primary Bedroom21.5015.00Primary Bedroom
Kitchen20.0013.00Kitchen
Bedroom 110.0015.00Bedroom
Family Room12.5013.50Family Room
Listing Documents
View Document New Attachment
View Document New Attachment
View Document New Attachment
View Document New Attachment
View Document New Attachment
View Document New Attachment

IDX
Listing Office: Coldwell Banker TEC

Last Updated: January - 12 - 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-349-8076
 

 

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®
    • Professional Development
  • Blog
  • 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