Back to Search Back to Listing

Ad #6568951

MLS #2600007874

Oh, the river views! A truly rare opportunity to own an

342 W Martial Ave, Lafayette, LA 70508

$1,495,000

4Beds

4Baths

4,044Sqft

1.24Acres

About this property

Oh, the river views! A truly rare opportunity to own an exceptional riverfront estate featuring 200 ft of river frontage on 1.24 acres, nestled in one of the area's most sought-after locations just minutes from River Ranch. Situated at the end of a private street, this sanctuary is surrounded by magnificent mature oak trees, two of which are proudly registered with the Live Oak Society. The property is serenely private, yet ideally positioned in the heart of the city. Thoughtfully designed and solidly built with solid wood doors throughout, this 4-bedroom, 3.5-bath home showcases timeless quality, generous living spaces, and breathtaking natural light. Nearly every room captures beautiful river views or the canopy of majestic oaks. Inside, the formal living and dining rooms feature rich hardwood floors and an elegant sense of scale. A spacious home office is filled with sunlight and enhanced by custom built-ins, while the generous den offers a warm gathering space centered around a wood-burning fireplace. The chef's kitchen features solid wood cabinetry, granite countertops, a walk-in pantry, a butler's pantry, and a dedicated appliance storage closet. Downstairs, the primary suite serves as a tranquil retreat with wood floors, scenic views, and dual walk-in closets. A convenient guest half bath and a spacious laundry room with a sink and built-in cabinetry complete the main level. Upstairs, three oversized bedrooms, a Jack-and-Jill bath, a second full bathroom, and a flexible bonus room accommodate family and guests with ease. Additional storage is plentiful with a fully floored attic. Outdoor living is truly second to none. Multiple balconies and porches invite you to enjoy morning coffee over the water, while a spectacular 12-foot-deep covered porch and expansive decking along the river create unmatched spaces for entertaining. Multiple pathways and fountains are encountered on a stroll through the grounds of this one-of-a-kind locale.

Property Features

4 Beds

4 Baths

4,044 Sqft

Built in 1993

1.24 Acres

2 Stories

Garage, Open

Siding: Brick

Composition Roof

Has Fireplace

Natural Gas, Central

Lafayette Parish County

Additional Photos

Contact Information

Eliana Ashkar

Latter & Blum Holdings LLC

337-739-7061

Location

Listing Agent: Eliana Ashkar (License #: 58222) 337-739-7061
Broker: Latter & Blum Holdings LLC 504-569-9369 Listing Site
Copyright © 2026 Realtor Association of Acadiana. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

BarrierFreeHome.com

Printed Oct 23, 2026

Photo Gallery

Oh, the river views! A truly rare opportunity to own an - photo 1

Oh, the river views! A truly rare opportunity to own an - photo 2

Oh, the river views! A truly rare opportunity to own an - photo 3

Oh, the river views! A truly rare opportunity to own an - photo 4

Oh, the river views! A truly rare opportunity to own an - photo 5

Oh, the river views! A truly rare opportunity to own an - photo 6

Oh, the river views! A truly rare opportunity to own an - photo 7

Oh, the river views! A truly rare opportunity to own an - photo 8

Oh, the river views! A truly rare opportunity to own an - photo 9

Oh, the river views! A truly rare opportunity to own an - photo 10

Oh, the river views! A truly rare opportunity to own an - photo 11

Oh, the river views! A truly rare opportunity to own an - photo 12

Oh, the river views! A truly rare opportunity to own an - photo 13

Oh, the river views! A truly rare opportunity to own an - photo 14

Oh, the river views! A truly rare opportunity to own an - photo 15

Oh, the river views! A truly rare opportunity to own an - photo 16

Oh, the river views! A truly rare opportunity to own an - photo 17

Oh, the river views! A truly rare opportunity to own an - photo 18

Oh, the river views! A truly rare opportunity to own an - photo 19

Oh, the river views! A truly rare opportunity to own an - photo 20

Oh, the river views! A truly rare opportunity to own an - photo 21

Oh, the river views! A truly rare opportunity to own an - photo 22

Oh, the river views! A truly rare opportunity to own an - photo 23

Oh, the river views! A truly rare opportunity to own an - photo 24

Oh, the river views! A truly rare opportunity to own an - photo 25

Oh, the river views! A truly rare opportunity to own an - photo 26

Oh, the river views! A truly rare opportunity to own an - photo 27

Oh, the river views! A truly rare opportunity to own an - photo 28

Oh, the river views! A truly rare opportunity to own an - photo 29

Oh, the river views! A truly rare opportunity to own an - photo 30

Oh, the river views! A truly rare opportunity to own an - photo 31

Oh, the river views! A truly rare opportunity to own an - photo 32

Oh, the river views! A truly rare opportunity to own an - photo 33

Oh, the river views! A truly rare opportunity to own an - photo 34

Oh, the river views! A truly rare opportunity to own an - photo 35

Oh, the river views! A truly rare opportunity to own an - photo 36

Oh, the river views! A truly rare opportunity to own an - photo 37

Oh, the river views! A truly rare opportunity to own an - photo 38

Oh, the river views! A truly rare opportunity to own an - photo 39

Oh, the river views! A truly rare opportunity to own an - photo 40

Oh, the river views! A truly rare opportunity to own an - photo 41

Oh, the river views! A truly rare opportunity to own an - photo 42

Oh, the river views! A truly rare opportunity to own an - photo 43

Oh, the river views! A truly rare opportunity to own an - photo 44

Oh, the river views! A truly rare opportunity to own an - photo 45

Oh, the river views! A truly rare opportunity to own an - photo 46

Oh, the river views! A truly rare opportunity to own an - photo 47

Oh, the river views! A truly rare opportunity to own an - photo 48

Oh, the river views! A truly rare opportunity to own an - photo 49

Oh, the river views! A truly rare opportunity to own an - photo 50

$1,495,000

Beds

Baths

4,044

Sqft

342 W Martial Ave, Lafayette, LA 70508

By contacting this agent you agree to these Terms and Conditions.

Home Louisiana Lafayette

MLS# 2600007874

Home Sale Pending

$1,495,000

342 W Martial Ave, Lafayette, LA 70508

Beds

Baths

4,044

Sqft

1.24

Acres

4 Beds

4 Baths

4,044 Sqft

1.24 Acres

Accessibility Features

Accessible Approach with Ramp

Oh, the river views! A truly rare opportunity to own an

48 days

on BarrierFreeHome.com

views

saves

Property Details

HOME DETAILS

4 Beds

4 Baths

4,044 Sqft

Built in 1993

1.24 Acres

2 Stories

EXTERIOR

Garage, Open

Siding: Brick

Composition Roof

INTERIOR

Has Fireplace

Natural Gas, Central

FINANCIAL & COMMUNITY

Lafayette Parish County

See More Details

Location

Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number

6568951

Viewed

40 times

Listing Status

Pending

Added

Sep 05, 2026

Last Refreshed

Oct 23, 2026 12:45:43 AM

Listing Information

Data Source

Realtor Association of Acadiana

Source Property ID

2600007874

Request Information

Send Me New Listings

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BarrierFreeHome.com

Sell Your Home

Explore Similar Properties

For Sale

Combining handicap-accessible first-floor living with a coveted - photo 1

Combining handicap-accessible first-floor living with a coveted - photo 2

Combining handicap-accessible first-floor living with a coveted - photo 3

Combining handicap-accessible first-floor living with a coveted - photo 4

Combining handicap-accessible first-floor living with a coveted - photo 5

Combining handicap-accessible first-floor living with a coveted - photo 6

Combining handicap-accessible first-floor living with a coveted - photo 7

Combining handicap-accessible first-floor living with a coveted - photo 8

Combining handicap-accessible first-floor living with a coveted - photo 9

Combining handicap-accessible first-floor living with a coveted - photo 10

Combining handicap-accessible first-floor living with a coveted - photo 11

Combining handicap-accessible first-floor living with a coveted - photo 12

Combining handicap-accessible first-floor living with a coveted - photo 13

Combining handicap-accessible first-floor living with a coveted - photo 14

Combining handicap-accessible first-floor living with a coveted - photo 15

Combining handicap-accessible first-floor living with a coveted - photo 16

Combining handicap-accessible first-floor living with a coveted - photo 17

Combining handicap-accessible first-floor living with a coveted - photo 18

Combining handicap-accessible first-floor living with a coveted - photo 19

Combining handicap-accessible first-floor living with a coveted - photo 20

Combining handicap-accessible first-floor living with a coveted - photo 21

Combining handicap-accessible first-floor living with a coveted - photo 22

Combining handicap-accessible first-floor living with a coveted - photo 23

Combining handicap-accessible first-floor living with a coveted - photo 24

Combining handicap-accessible first-floor living with a coveted - photo 25

Combining handicap-accessible first-floor living with a coveted - photo 26

Combining handicap-accessible first-floor living with a coveted - photo 27

Combining handicap-accessible first-floor living with a coveted - photo 28

Combining handicap-accessible first-floor living with a coveted - photo 29

Combining handicap-accessible first-floor living with a coveted - photo 30

Combining handicap-accessible first-floor living with a coveted - photo 31

Combining handicap-accessible first-floor living with a coveted - photo 32

Combining handicap-accessible first-floor living with a coveted - photo 33

Combining handicap-accessible first-floor living with a coveted - photo 34

Combining handicap-accessible first-floor living with a coveted - photo 35

Combining handicap-accessible first-floor living with a coveted - photo 36

Combining handicap-accessible first-floor living with a coveted - photo 37

Combining handicap-accessible first-floor living with a coveted - photo 38

Combining handicap-accessible first-floor living with a coveted - photo 39

Combining handicap-accessible first-floor living with a coveted - photo 40

Combining handicap-accessible first-floor living with a coveted - photo 41

Combining handicap-accessible first-floor living with a coveted - photo 42

Combining handicap-accessible first-floor living with a coveted - photo 43

Combining handicap-accessible first-floor living with a coveted - photo 44

Combining handicap-accessible first-floor living with a coveted - photo 45

Combining handicap-accessible first-floor living with a coveted - photo 46

Combining handicap-accessible first-floor living with a coveted - photo 47

Combining handicap-accessible first-floor living with a coveted - photo 48

Combining handicap-accessible first-floor living with a coveted - photo 49

Combining handicap-accessible first-floor living with a coveted - photo 50

Combining handicap-accessible first-floor living with a coveted - photo 51

Combining handicap-accessible first-floor living with a coveted - photo 52

Combining handicap-accessible first-floor living with a coveted - photo 53

Combining handicap-accessible first-floor living with a coveted - photo 54

Combining handicap-accessible first-floor living with a coveted - photo 55

Combining handicap-accessible first-floor living with a coveted - photo 56

Combining handicap-accessible first-floor living with a coveted - photo 57

Combining handicap-accessible first-floor living with a coveted - photo 58

Combining handicap-accessible first-floor living with a coveted - photo 59

Combining handicap-accessible first-floor living with a coveted - photo 60

$1,650,000

4 Beds | 5.0 Baths | 6,210 Sqft

327 Beverly Dr, Lafayette, LA 70503

Combining handicap-accessible first-floor living with a coveted

Added: 08/24/2025 • Updated: 10/08/2026

For Sale

Here's a rare opportunity for true estate living in the heart of - photo 1

Here's a rare opportunity for true estate living in the heart of - photo 2

Here's a rare opportunity for true estate living in the heart of - photo 3

Here's a rare opportunity for true estate living in the heart of - photo 4

Here's a rare opportunity for true estate living in the heart of - photo 5

Here's a rare opportunity for true estate living in the heart of - photo 6

Here's a rare opportunity for true estate living in the heart of - photo 7

Here's a rare opportunity for true estate living in the heart of - photo 8

Here's a rare opportunity for true estate living in the heart of - photo 9

Here's a rare opportunity for true estate living in the heart of - photo 10

Here's a rare opportunity for true estate living in the heart of - photo 11

Here's a rare opportunity for true estate living in the heart of - photo 12

Here's a rare opportunity for true estate living in the heart of - photo 13

Here's a rare opportunity for true estate living in the heart of - photo 14

Here's a rare opportunity for true estate living in the heart of - photo 15

Here's a rare opportunity for true estate living in the heart of - photo 16

Here's a rare opportunity for true estate living in the heart of - photo 17

Here's a rare opportunity for true estate living in the heart of - photo 18

Here's a rare opportunity for true estate living in the heart of - photo 19

Here's a rare opportunity for true estate living in the heart of - photo 20

Here's a rare opportunity for true estate living in the heart of - photo 21

Here's a rare opportunity for true estate living in the heart of - photo 22

Here's a rare opportunity for true estate living in the heart of - photo 23

Here's a rare opportunity for true estate living in the heart of - photo 24

Here's a rare opportunity for true estate living in the heart of - photo 25

Here's a rare opportunity for true estate living in the heart of - photo 26

Here's a rare opportunity for true estate living in the heart of - photo 27

Here's a rare opportunity for true estate living in the heart of - photo 28

Here's a rare opportunity for true estate living in the heart of - photo 29

Here's a rare opportunity for true estate living in the heart of - photo 30

Here's a rare opportunity for true estate living in the heart of - photo 31

Here's a rare opportunity for true estate living in the heart of - photo 32

Here's a rare opportunity for true estate living in the heart of - photo 33

Here's a rare opportunity for true estate living in the heart of - photo 34

Here's a rare opportunity for true estate living in the heart of - photo 35

Here's a rare opportunity for true estate living in the heart of - photo 36

Here's a rare opportunity for true estate living in the heart of - photo 37

Here's a rare opportunity for true estate living in the heart of - photo 38

Here's a rare opportunity for true estate living in the heart of - photo 39

Here's a rare opportunity for true estate living in the heart of - photo 40

Here's a rare opportunity for true estate living in the heart of - photo 41

Here's a rare opportunity for true estate living in the heart of - photo 42

Here's a rare opportunity for true estate living in the heart of - photo 43

Here's a rare opportunity for true estate living in the heart of - photo 44

Here's a rare opportunity for true estate living in the heart of - photo 45

Here's a rare opportunity for true estate living in the heart of - photo 46

Here's a rare opportunity for true estate living in the heart of - photo 47

Here's a rare opportunity for true estate living in the heart of - photo 48

Here's a rare opportunity for true estate living in the heart of - photo 49

Here's a rare opportunity for true estate living in the heart of - photo 50

$1,300,000

5 Beds | 6.0 Baths | 6,226 Sqft

101 Farmington Dr, Lafayette, LA 70503

Here's a rare opportunity for true estate living in the heart of

Added: 10/09/2026 • Updated: 10/12/2026

Sale Pending

This spectacular, single-story dream home sits on a coveted - photo 1

This spectacular, single-story dream home sits on a coveted - photo 2

This spectacular, single-story dream home sits on a coveted - photo 3

This spectacular, single-story dream home sits on a coveted - photo 4

This spectacular, single-story dream home sits on a coveted - photo 5

This spectacular, single-story dream home sits on a coveted - photo 6

This spectacular, single-story dream home sits on a coveted - photo 7

This spectacular, single-story dream home sits on a coveted - photo 8

This spectacular, single-story dream home sits on a coveted - photo 9

This spectacular, single-story dream home sits on a coveted - photo 10

This spectacular, single-story dream home sits on a coveted - photo 11

This spectacular, single-story dream home sits on a coveted - photo 12

This spectacular, single-story dream home sits on a coveted - photo 13

This spectacular, single-story dream home sits on a coveted - photo 14

This spectacular, single-story dream home sits on a coveted - photo 15

This spectacular, single-story dream home sits on a coveted - photo 16

This spectacular, single-story dream home sits on a coveted - photo 17

This spectacular, single-story dream home sits on a coveted - photo 18

This spectacular, single-story dream home sits on a coveted - photo 19

This spectacular, single-story dream home sits on a coveted - photo 20

This spectacular, single-story dream home sits on a coveted - photo 21

This spectacular, single-story dream home sits on a coveted - photo 22

This spectacular, single-story dream home sits on a coveted - photo 23

This spectacular, single-story dream home sits on a coveted - photo 24

This spectacular, single-story dream home sits on a coveted - photo 25

This spectacular, single-story dream home sits on a coveted - photo 26

This spectacular, single-story dream home sits on a coveted - photo 27

This spectacular, single-story dream home sits on a coveted - photo 28

This spectacular, single-story dream home sits on a coveted - photo 29

This spectacular, single-story dream home sits on a coveted - photo 30

This spectacular, single-story dream home sits on a coveted - photo 31

This spectacular, single-story dream home sits on a coveted - photo 32

This spectacular, single-story dream home sits on a coveted - photo 33

This spectacular, single-story dream home sits on a coveted - photo 34

This spectacular, single-story dream home sits on a coveted - photo 35

This spectacular, single-story dream home sits on a coveted - photo 36

This spectacular, single-story dream home sits on a coveted - photo 37

This spectacular, single-story dream home sits on a coveted - photo 38

This spectacular, single-story dream home sits on a coveted - photo 39

This spectacular, single-story dream home sits on a coveted - photo 40

This spectacular, single-story dream home sits on a coveted - photo 41

This spectacular, single-story dream home sits on a coveted - photo 42

This spectacular, single-story dream home sits on a coveted - photo 43

This spectacular, single-story dream home sits on a coveted - photo 44

This spectacular, single-story dream home sits on a coveted - photo 45

This spectacular, single-story dream home sits on a coveted - photo 46

$1,200,000

3 Beds | 4.0 Baths | 3,578 Sqft

301 Girard Park Dr, Lafayette, LA 70503

This spectacular, single-story dream home sits on a coveted

Added: 08/01/2026 • Updated: 10/08/2026

View More in Lafayette View More in Lafayette

SEARCH STATES

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

SERVICES

Buy Buy Advertise

COMPANY

Testimonials About Us Office Locations

SUPPORT

Help Contact Us

ADDITIONAL MARKETS

LakeHouse.com MountainHomes.com BeachHouse.com GolfHomes.com

Receive notifications for new listings

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 Wheelchair-accessible Housing & Universal Design Homes at Barrier Free Home
Part of Dream Home Network, Inc.
Last updated on 2026.10.23
Terms & Policy

About this property

Property Features

Additional Photos

Contact Information

Location

Oh, the river views! A truly rare opportunity to own an

Property Details

HOME DETAILS

EXTERIOR

INTERIOR

FINANCIAL & COMMUNITY

Location

Mortgage Calculator

Listing Information

Request Information

Start advertising today

Lafayette

Lafayette Real Estate Agent Info

About Lafayette

INTERIOR

FINANCIAL & COMMUNITY

Search Filters

Lafayette

Lafayette Real Estate Agent Info

About Lafayette