207 Farmington Drive, Lafayette, LA 70503
$1,200,000
Property Type:
Residential
Bedrooms:
6
Baths:
6.1
Square Footage:
10,238
Lot Size (sq. ft.):
76,230
Status:
Pending
Current Price:
$1,200,000
List Date:
4/02/2026
Last Modified:
4/09/2026
Listing Details MLS# 2600002793
Listing Info
- Delayed Marketing
- No
- Listing Price
- 1200000
- List Price/SqFt
- 159.51
- Type
- Single Family Residence
- Property Attached
- No
- Document Modified
- 2026-04-06 13:40:40.368364
- Modification Timestamp
- 2026-04-09T20:52:48Z
- Photo Modified
- 2026-04-04T14:38:37Z
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).
General Property Description
- # Bedrooms
- 6
- Baths - Full
- 6
- Baths - 1/2
- Yes
- Total Baths
- 6.1
- SqFt - Living
- 7523
- SqFt - Total
- 10238
- SqFt - Source
- Owner
- Stories
- 2
- Year Built
- 1998
- Approximate Age
- 21 - 30 Years
- Property Condition
- Resale
- Condition
- Excellent
- Warranty
- No
- Acres
- 1.75
- Acreage Range
- 1 - 2.99
- Assn Fee
- Required
- Assn Fee $
- 389
- Assn Fee Terms
- Yearly
- Lot Dimensions
- IRREGULAR
- Mineral Rights
- Conveyed
- Pool on Subject Property
- Yes
Status Change Info
- Under Contract Date
- 2026-04-09
Parking
- Garage Spaces
- 4
- Garage Faces Side
- Yes
Water Source
- Water Company
- LUS
- Public
- Yes
More Information
Originating Details
- Originating System ID
- M00000300
- Originating System Key
- 20260401202450584899
- Originating System Listing ID
- 2600002793
- Originating System Name
- RAA Flex
Location, Tax & Legal Info
- Flood Zone
- X
- School District
- Lafayette Parish
- Legal Desc
- LOT 162 AND 50FT OF LOT 161 OF FERNEWOOD
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
- Yes
Siding
- Stucco
- Yes
- Other
- Yes
Equipment
- Garage Door Opener
- Yes
- Central Vacuum
- Yes
- Sauna/Steam
- Yes
- Whirlpool
- Yes
- Ceiling Fans
- Yes
- Cable Ready
- Yes
Road Frontage
- City Street
- Yes
Construction
- Frame
- Yes
Foundation
- Slab
- Yes
Exterior
- Balcony
- Yes
- Outdoor Shower
- Yes
Patio
- Deck
- Yes
- Porch
- Yes
- Covered
- Yes
Fireplace
- 2 Fireplaces
- Yes
- Double Sided
- Yes
- Gas
- Yes
Roof
- Other
- Yes
Heating
- Central
- Yes
- Multi Units
- Yes
- Natural Gas
- Yes
Interior
- 9+ Ft Ceiling
- Yes
- Attic Access
- Yes
- Bookcases
- Yes
- Built-Ins
- Yes
- Computer Nook
- Yes
- Crown Molding
- Yes
- Guest Suite
- Yes
- Kitchen Island
- Yes
- Primary Bath
- Yes
- Multi-Head Shower
- Yes
- Varied Ceiling Heights
- Yes
- Vaulted Ceilings
- Yes
- Walk-In Closet(s)
- Yes
- Wet Bar
- Yes
- Window Treatments
- Yes
Cooling
- 2 or More Units
- Yes
- Central Air
- Yes
Flooring
- Brick
- Yes
- Carpet
- Yes
- Tile
- Yes
- Wood
- Yes
Sewer
- Public Sewer
- Yes
Appliances
- Dishwasher
- Yes
- Disposal
- Yes
- Gas Cooktop
- Yes
- Microwave
- Yes
- Plumbed For Ice Maker
- Yes
- Refrigerator
- Yes
- Trash Compactor
- Yes
Utilities
- Elec: City
- Yes
- Gas: Atmos
- Yes
Countertops
- Granite
- Yes
- Tile
- Yes
Waterfront
- Bayou/River
- Yes
Documents
- Property Disclosure
- Yes
Amenities
- Acreage
- Yes
- Park
- Yes
- Playground
- Yes
Security Features
- Security System
- Yes
- Smoke Detector(s)
- Yes
Fencing
- Partial
- Yes
Lot
- Back Yard Access
- Yes
- Landscaped
- Yes
- Sloping
- Yes
- Views
- Yes
- Water Frontage
- Yes
Other Structures
- Cabana
- Yes
- Gazebo
- Yes
- Guest House
- Yes
- Storage
- Yes
Financing
- Cash
- Yes
- Conventional
- Yes
Reserved Item
- Other - See Remarks
- Yes
Pool
- Gunite
- Yes
- Inground
- Yes
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
Documents
Flood Determination Disclosure ›
IDX
Listing Office:
Real Broker, LLC
Last Updated: April - 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.