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

$1,195,000
4118 FRERET Street
New Orleans, LA 70115
MLS# NO2553226
5 beds  |  4.1 baths  |  5014 sqft


Photo 1
  1 / 57  
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

Property Description
NEW PRICE IMPROVEMENT OFFERS THIS AMAZING PROPERTY BELOW RECENT APPRAISED VALUE! An Uptown standout located just 3 blocks to vibrant Freret Street! Shop the new Trader Joes & Rouses market, dine at beloved local eateries, and just over 1 mile to Tulane University/Audubon Park. Freret Fest, select Uptown Mardi Gras parades, and the Napoleon wellness path, are just a few perks to enjoy in this fast growing neighborhood. This property is situated on a generously sized 30x150, low maintenance lot and seamlessly blends luxury with convenience. Two structures (renovated/completed in 2023) with individual meters create a rare opportunity to owner occupy entire property or flexibility to add an income producing property. A unique, light-filled sitting room connects the two houses with option to close down one if elect to use portion as a rental. Beautiful steel accordion doors flow out to bamboo deck with Brecco wood-burning fire pit, 7-person hot tub in excellent condition & retractable screen for outdoor movie nights enjoyed with friends & family. This property also comes with gated off street parking. The front cottage (4118) features 2 bedrooms, 2 full baths is filled with vibrant color and classic New Orleans charm. Vaulted ceilings in the kitchen/living area, wood floors, high ceilings and bathrooms adorned with Morroccan plaster walls. The rear house (4120) offers 3 bedrooms, 2.5 baths, 12 ft ceilings, fenced backyard with infrared sauna & expansive rooftop deck. The first floor showcases a modern open concept with stained concrete floors, RH lighting, copper farmhouse sink, walnut countertops, and GE Cafe series appliances with custom bronze hardware. Primary bedroom on the second level with 2 additional bedrooms, Jack & Jill bath, and laundry space. Don't miss the stunning third floor rooftop deck with gorgeous views of the city and gas fire pit.

Details
Documents
Listing Info
Status: Active
Listing Date: 2026-04-22
Delayed Marketing: No
Listing Price: 1195000
Current Price: $1,195,000
List Price/SqFt: 384.86
Type: Single Family Residence
Document Modified: 2026-08-10 19:53:06.084670
Modification Timestamp: 2026-09-13T06:42:22Z
Photo Modified: 2026-08-05T13:17:58Z
General Property Description
# Bedrooms: 5
Baths - Full: 4
Baths - 1/2: 1
Total Baths: 4.1
SqFt - Living: 3105
SqFt - Total: 5014
SqFt - Source: Measured
Stories: 2
Year Built: 2023
Acreage Range: 0 - 0.5
Lot Dimensions: 30 x 150
Pool on Subject Property: No
Originating Details
Originating System ID: ROAMM
Originating System Key: 57777643
Originating System Listing ID: 2553226
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 4118
Street Name: FRERET Street
Parish: Orleans
State: LA
Zip Code: 70115
Tax Assessment Number: 4118-FRERETST
Directions: Bounding Streets: Marengo, Milan, LaSalle
Property Features
Style: Contemporary
Foundation: Piers
Roof: Composition; Metal
Interior: Attic Access; Cathedral Ceiling
Fireplace: Other
Heating: Central; Other
Cooling: 2 or More Units; Central Air; Other
Appliances: Dishwasher; Disposal; Dryer; Refrigerator; Washer
Rooms: Bathroom 1; Bedroom 1; Dining Room; Kitchen; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bathroom 2; Bathroom 3; Bathroom 4; Bathroom 5
Fencing: Wood; Other
Utilities: Elec: Entergy
Room Information
Room Name Length Width Remarks
Kitchen14.0016.20Kitchen
Kitchen15.4010.10Kitchen
Bathroom 18.505.70Bathroom
Bathroom 27.905.50Bathroom
Bathroom 39.208.50Bathroom
Living Room15.4010.10Living Room
Living Room16.2013.30Living Room
Primary Bedroom13.0016.40Primary Bedroom
Primary Bedroom13.0016.40Primary Bedroom
Primary Bedroom10.5014.20Primary Bedroom
Dining Room16.2014.50Dining Room
Bathroom 49.8012.00Bathroom
Bedroom 19.7010.70Bedroom
Bathroom 59.8012.00Bathroom
Bedroom 211.0011.00Bedroom
Bedroom 313.004.80Bedroom
Bedroom 411.0011.00Bedroom
Listing Documents
View Document New Attachment
View Document New Attachment
View Document New Attachment
View Document New Attachment

IDX
Listing Office: Valmont Realtors

Last Updated: September - 13 - 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