$1,345,000
New Orleans, LA 70115
MLS# NO2553226
5 beds | 4.1 baths | 5014 sqft
1 / 54
Property Description
Picture your mornings with coffee on your 983 sq ft rooftop deck and evenings unwinding in your private hot tub beside a fire. This modern single family home offers more than just square footage- it delivers a lifestyle. Situated on a generously sized, low maintenance lot in Uptown's rapidly growing Freret neighborhood, it seamlessly blends luxury with convenience. Two separate structures both renovated/completed in 2023 with individual meters create a rare opportunity for rental income and/or owner occupancy. The front cottage (4118) features 2 bedrooms, 2 full baths filled with vibrant color and classic New Orleans charm. The main residence (4120) offers 3 bedrooms, 2.5 baths, gated off-street parking, steel accordion sliding doors that open to the side deck and a rear fenced backyard. Inside, the first floor showcases stained concrete floors, RH lighting, copper farmhouse sink, walnut countertops and GE Cafe series appliances with custom bronze hardware & Hunter Douglas automated blinds. Enjoy an exceptional lineup of amenities, including an infrared sauna, expansive rooftop entertaining space with gas fire pit, a Brecco wood-burning fire pit on lower deck, a hot tub and a retractable screen for outdoor movie nights with friends & family. A true Uptown standout-don't miss it
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 433.17
Document Modified: 2026-05-05 15:32:38.458955
Status: Active
Listing Date: 2026-04-22
Listing Price: 1345000
Current Price: $1,345,000
Type: Single Family Residence
Modification Timestamp: 2026-06-07T07:11:12Z
Photo Modified: 2026-05-05T11:55:43Z
Location, Tax & Legal Info
Legal Desc: SQ 587 LOT 24 FRERET 30X150 S-W
General Property Description
Lot Dimensions: 30 x 150
Stories: 2
SqFt - Living: 3105
SqFt - Source: Measured
SqFt - Total: 5014
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 5
Baths - Full: 4
Baths - 1/2: 1
Total Baths: 4.1
Year Built: 2023
Remarks & Misc
Remarks: Picture your mornings with coffee on your 983 sq ft rooftop deck and evenings unwinding in your private hot tub beside a fire. This modern single family home offers more than just square footage- it delivers a lifestyle. Situated on a generously sized, low maintenance lot in Uptown's rapidly growing Freret neighborhood, it seamlessly blends luxury with convenience. Two separate structures both renovated/completed in 2023 with individual meters create a rare opportunity for rental income and/or owner occupancy. The front cottage (4118) features 2 bedrooms, 2 full baths filled with vibrant color and classic New Orleans charm. The main residence (4120) offers 3 bedrooms, 2.5 baths, gated off-street parking, steel accordion sliding doors that open to the side deck and a rear fenced backyard. Inside, the first floor showcases stained concrete floors, RH lighting, copper farmhouse sink, walnut countertops and GE Cafe series appliances with custom bronze hardware & Hunter Douglas automated blinds. Enjoy an exceptional lineup of amenities, including an infrared sauna, expansive rooftop entertaining space with gas fire pit, a Brecco wood-burning fire pit on lower deck, a hot tub and a retractable screen for outdoor movie nights with friends & family. A true Uptown standout-don't miss it
Office/Member/Contract Info
List AOR: NOMAR
Style
Contemporary: 1
Foundation
Piers: 1
Fireplace
Other: 1
Roof
Composition: 1
Metal: 1
Heating
Central: 1
Other: 1
Interior
Attic Access: 1
Cathedral Ceiling: 1
Cooling
2 or More Units: 1
Central Air: 1
Other: 1
Appliances
Dishwasher: 1
Disposal: 1
Dryer: 1
Refrigerator: 1
Washer: 1
Utilities
Elec: Entergy: 1
Rooms
Bathroom 1: 1
Bedroom 1: 1
Dining Room: 1
Kitchen: 1
Living Room: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Bathroom 2: 1
Bathroom 3: 1
Bathroom 4: 1
Bathroom 5: 1
Fencing
Wood: 1
Other: 1
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 |
| Kitchen | 14.00 | 16.20 | Kitchen |
| Kitchen | 15.40 | 10.10 | Kitchen |
| Bathroom 1 | 8.50 | 5.70 | Bathroom |
| Bathroom 2 | 7.90 | 5.50 | Bathroom |
| Bathroom 3 | 9.20 | 8.50 | Bathroom |
| Living Room | 15.40 | 10.10 | Living Room |
| Living Room | 16.20 | 13.30 | Living Room |
| Primary Bedroom | 13.00 | 16.40 | Primary Bedroom |
| Primary Bedroom | 13.00 | 16.40 | Primary Bedroom |
| Primary Bedroom | 10.50 | 14.20 | Primary Bedroom |
| Dining Room | 16.20 | 14.50 | Dining Room |
| Bathroom 4 | 9.80 | 12.00 | Bathroom |
| Bedroom 1 | 9.70 | 10.70 | Bedroom |
| Bathroom 5 | 9.80 | 12.00 | Bathroom |
| Bedroom 2 | 11.00 | 11.00 | Bedroom |
| Bedroom 3 | 13.00 | 4.80 | Bedroom |
| Bedroom 4 | 11.00 | 11.00 | Bedroom |
New Attachment IDX
Listing Office: Valmont Realtors
Last Updated: June - 07 - 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.