$1,200,000
Lafayette, LA 70503
MLS# 2600002793
6 beds | 6.1 baths | 10238 sqft
1 / 54
Property Description
Welcome to 207 Farmington, an exceptional waterfront residence located in the heart of Lafayette. This one-of-a-kind property seamlessly blends timeless character with upscale outdoor living, offering a rare opportunity to own a true retreat within city limits. Positioned with the river directly behind the home, the property captures serene water views and a sense of privacy that is hard to find. The backyard is designed for resort-style living, featuring a stunning in-ground infinity pool overlooking the water, a well-appointed gazebo, and expansive space ideal for entertaining or relaxing in a peaceful setting. Inside, the home is rich in character with beautiful antique doors that add warmth, charm, and architectural interest throughout. Generous living spaces provide both comfort and functionality, while a private mother-in-law suite offers flexibility for guests, extended family, or multi-generational living. With its unique combination of waterfront access, luxury outdoor amenities, and distinctive design elements, this property stands out as a rare offering in Lafayette. Conveniently located near shopping, dining, and everyday conveniences, it delivers both tranquility and accessibility. This exceptional home is truly a must-see for those seeking luxury, character, and a premier waterfront lifestyle. Preferred Lender offering $8,000 in CC
Details
Listing Info
Delayed Marketing: No
List Price/SqFt: 159.51
Property Attached: No
Document Modified: 2026-04-02 17:57:53.468572
Status: Active
Listing Date: 2026-04-02
Listing Price: 1200000
Current Price: $1,200,000
Type: Single Family Residence
Modification Timestamp: 2026-04-04T17:14:30Z
Photo Modified: 2026-04-04T14:38:37Z
Location, Tax & Legal Info
Flood Zone: X
School District: Lafayette Parish
Legal Desc: LOT 162 AND 50FT OF LOT 161 OF FERNEWOOD
General Property Description
Approximate Age: 21 - 30 Years
Condition: Excellent
Lot Dimensions: IRREGULAR
Stories: 2
SqFt - Living: 7523
SqFt - Source: Owner
SqFt - Total: 10238
Mineral Rights: Conveyed
Assn Fee: Required
Assn Fee $: 389
Assn Fee Terms: Yearly
Property Condition: Resale
Warranty: No
Acreage Range: 1 - 2.99
Pool on Subject Property: Yes
# Bedrooms: 6
Baths - Full: 6
Baths - 1/2: 1
Total Baths: 6.1
Year Built: 1998
Acres: 1.75
Remarks & Misc
Remarks: Welcome to 207 Farmington, an exceptional waterfront residence located in the heart of Lafayette. This one-of-a-kind property seamlessly blends timeless character with upscale outdoor living, offering a rare opportunity to own a true retreat within city limits.
Positioned with the river directly behind the home, the property captures serene water views and a sense of privacy that is hard to find. The backyard is designed for resort-style living, featuring a stunning in-ground infinity pool overlooking the water, a well-appointed gazebo, and expansive space ideal for entertaining or relaxing in a peaceful setting.
Inside, the home is rich in character with beautiful antique doors that add warmth, charm, and architectural interest throughout. Generous living spaces provide both comfort and functionality, while a private mother-in-law suite offers flexibility for guests, extended family, or multi-generational living.
With its unique combination of waterfront access, luxury outdoor amenities, and distinctive design elements, this property stands out as a rare offering in Lafayette. Conveniently located near shopping, dining, and everyday conveniences, it delivers both tranquility and accessibility.
This exceptional home is truly a must-see for those seeking luxury, character, and a premier waterfront lifestyle.
Preferred Lender offering $8,000 in CC
Office/Member/Contract Info
REO: No
Style
Traditional: 1
Siding
Stucco: 1
Other: 1
Parking
Garage Spaces: 4
Garage Faces Side: 1
Equipment
Garage Door Opener: 1
Central Vacuum: 1
Sauna/Steam: 1
Whirlpool: 1
Ceiling Fans: 1
Cable Ready: 1
Road Frontage
City Street: 1
Construction
Frame: 1
Foundation
Slab: 1
Exterior
Balcony: 1
Outdoor Shower: 1
Patio
Deck: 1
Porch: 1
Covered: 1
Fireplace
2 Fireplaces: 1
Double Sided: 1
Gas: 1
Roof
Other: 1
Heating
Central: 1
Multi Units: 1
Natural Gas: 1
Interior
9+ Ft Ceiling: 1
Attic Access: 1
Bookcases: 1
Built-Ins: 1
Computer Nook: 1
Crown Molding: 1
Guest Suite: 1
Kitchen Island: 1
Primary Bath: 1
Multi-Head Shower: 1
Varied Ceiling Heights: 1
Vaulted Ceilings: 1
Walk-In Closet(s): 1
Wet Bar: 1
Window Treatments: 1
Cooling
2 or More Units: 1
Central Air: 1
Flooring
Brick: 1
Carpet: 1
Tile: 1
Wood: 1
Sewer
Public Sewer: 1
Water Source
Public: 1
Water Company: LUS
Appliances
Dishwasher: 1
Disposal: 1
Gas Cooktop: 1
Microwave: 1
Plumbed For Ice Maker: 1
Refrigerator: 1
Trash Compactor: 1
Utilities
Elec: City: 1
Gas: Atmos: 1
Countertops
Granite: 1
Tile: 1
Waterfront
Bayou/River: 1
Documents
Property Disclosure: 1
Amenities
Acreage: 1
Park: 1
Playground: 1
Security Features
Security System: 1
Smoke Detector(s): 1
Fencing
Partial: 1
Lot
Back Yard Access: 1
Landscaped: 1
Sloping: 1
Views: 1
Water Frontage: 1
Other Structures
Cabana: 1
Gazebo: 1
Guest House: 1
Storage: 1
Financing
Cash: 1
Conventional: 1
Reserved Item
Other - See Remarks: 1
Pool
Gunite: 1
Inground: 1
Originating Details
Originating System ID: M00000300
Originating System Key: 20260401202450584899
Originating System Listing ID: 2600002793
Originating System Name: RAA Flex
Location Tax Legal Info
Street Number: 207
Street Name: Farmington
St Suffix: Drive
Parish: Lafayette
State: LA
Zip Code: 70503
Subdivision: Fernewood
Area: N
Tax Assessment Number: 6085335
Elementary School: Broadmoor
Middle School: Edgar Martin
High School: Lafayette
Directions: From Johnston Street, head south on Ambassador Caffery Parkway toward the Johnston/Ambassador intersection. Just past the intersection, turn right into the Farmington subdivision (Farmington Drive).
Property Features
Style: Traditional
Siding: Stucco; Other
Parking: Garage Faces Side
Construction: Frame
Foundation: Slab
Road Frontage: City Street
Roof: Other
Interior: 9+ Ft Ceiling; Attic Access; Bookcases; Built-Ins; Computer Nook; Crown Molding; Guest Suite; Kitchen Island; Multi-Head Shower; Primary Bath; Varied Ceiling Heights; Vaulted Ceilings; Walk-In Closet(s); Wet Bar; Window Treatments
Fireplace: 2 Fireplaces; Double Sided; Gas
Flooring: Brick; Carpet; Tile; Wood
Heating: Central; Multi Units; Natural Gas
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Gas Cooktop; Microwave; Plumbed For Ice Maker; Refrigerator; Trash Compactor
Countertops: Granite; Tile
Security Features: Security System; Smoke Detector(s)
Fencing: Partial
Lot: Back Yard Access; Landscaped; Sloping; Views; Water Frontage
Patio: Covered; Deck; Porch
Amenities: Acreage; Park; Playground
Exterior: Balcony; Outdoor Shower
Other Structures: Cabana; Gazebo; Guest House; Storage
Waterfront: Bayou/River
Sewer: Public Sewer
Water Source: Public
Utilities: Elec: City; Gas: Atmos
Pool: Gunite; Inground
Reserved Item: Other - See Remarks
Financing: Cash; Conventional
Documents: Property Disclosure; Property Disclosure
IDX
Listing Office: Real Broker, LLC
Last Updated: April - 04 - 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.
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.