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

Agent on Call

agent

Candice Scriber, REALTOR® Sales Associate
337-277-6503


$675,000
1238 N ROBERTSON Street
New Orleans, LA 70116
MLS# NO2570833
Status: Pending
5 beds  |  4.1 baths  |  4251 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
Officially classified, as a "BED & BREAKFAST"Hotel License! This beautifully restored two-story historic home in Treme, just a block from Esplanade Avenue, features a new roof (2021), open-concept living areas, ideal for entertaining, and a mix of modern updates with classic charm. It offers five bedrooms (one downstairs), a spacious primary suite with a versatile sitting area, and upstairs balcony access. The property includes gated parking, a covered patio, space for a pool, a storage shed, and a Bed and Breakfast license--an investors delight! Palm trees, large sun-filled windows, and a security system to complete this charming, gated residence. Steps away from Jazz Festival, short distance to French Quarter and Downtown New Orleans, Lil Dizzys restaurant and more. You must see this exquisite home in person to appreciate the renovation, charm, beauty, and potential of residing in this absolutely lovely space or using this stately home for investment purposes. You must see this beauty in person to appreciate all that the space has to offer. Location, Location, Location! ALSO, THIS PROPERTY MAY QUALIFY FOR 100% FINANCING with NO PMI, $5,000 LENDER CREDIT great low fixed rate and NO INCOME LIMITS! Don't let this opportunity pass ou by. Call me for details!

Details
Documents
Listing Info
Status: Pending
Listing Date: 2026-08-04
Delayed Marketing: No
Listing Price: 675000
Current Price: $675,000
List Price/SqFt: 182.33
Type: Single Family Residence
Document Modified: 2026-09-27 12:37:07.495781
Modification Timestamp: 2026-09-27T17:37:32Z
Photo Modified: 2026-08-04T15:44:39Z
General Property Description
# Bedrooms: 5
Baths - Full: 4
Baths - 1/2: 1
Total Baths: 4.1
SqFt - Living: 3702
SqFt - Total: 4251
SqFt - Source: Appraiser
Stories: 2
Year Built: 1887
Acres: 0.12
Acreage Range: 0 - 0.5
Lot Dimensions: 46 x 112
Originating Details
Originating System ID: ROAMM
Originating System Key: 59319905
Originating System Listing ID: 2570833
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 1238
Dir: N
Street Name: ROBERTSON Street
Parish: Orleans
State: LA
Zip Code: 70116
Tax Assessment Number: 208104212
Directions: North Claiborne to Esplanade (toward French Quarter) and right on North Robertson Bounding Streets: North Claiborne, Esplanade, Governor Nichols
Status Change Info
Under Contract Date: 2026-09-24
Property Features
Style: Other
Parking: Carport
Construction: Frame; Other
Foundation: Piers
Roof: Other
Fireplace: Other
Heating: Central
Cooling: 2 or More Units; Central Air
Countertops: Granite
Rooms: Bathroom 1; Bedroom 1; Den; Dining Room; Kitchen; Laundry; Living Room; Office; Primary Bathroom; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bathroom 2; Bathroom 3; Bathroom 4
Fencing: Brick; Full; Other
Patio: Covered; Porch
Other Structures: Workshop
Utilities: Elec: Entergy
Room Information
Room Name Length Width Remarks
Laundry12.006.30Laundry
Laundry5.508.70Laundry
Bathroom 112.006.60Bathroom
Living Room14.2019.70Living Room
Bathroom 25.806.20Bathroom
Bathroom 36.204.10Half Bath
Den13.7021.60Den
Primary Bathroom12.308.80Primary Bathroom
Dining Room12.8019.70Dining Room
Office12.008.00Office
Bedroom 113.6021.60Bedroom
Bedroom 213.6013.30Bedroom
Bedroom 313.1018.30Bedroom
Bedroom 413.4012.20Bedroom
Kitchen13.3015.50Kitchen
Primary Bedroom27.1012.30Primary Bedroom
Bathroom 49.308.10Bathroom
Listing Documents
View Document New Attachment
View Document New Attachment
View Document New Attachment
View Document New Attachment

IDX
Listing Office: Russell Frank Realty Group, L.L.C.

Last Updated: September - 27 - 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-277-6503

 

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