🏦 Get Your Mortgage or Real Estate Services Seen on Every Listing

Thousands of buyers and investors explore commercial, residential, and business listings every day on LoopingCloud.
Promote your mortgage services or real estate business directly on each listing by state, boost your visibility and connect instantly with serious prospects ready to take the next step.

Offer Your Real Estate Services Today Get started Offer Your Mortgage Services Today Get started
Published on: Mon, Jun 09, 2025 9:36 AM
Updated on: Mon, Jun 09, 2025 9:51 AM
About the Lister
User Profile Image
Name: Chris Talbot
Company: Talbot Realty Group
Office Phone: (504) 319-1452
Cell Phone: (504) 319-1452
Provide Your Service
Financing  Business  Material

  Two Custom Homes on One Lot on Iconic Esplanade Ave – Liv...

2220 E Business Highway 83 Mission Texas , 78572
2220 E Business Highway 83 Mission Texas                                                                                               , 78572  FORUM CRE
Listing ID: RL-Louisiana-25554 Condo/Townhouse/Residential Type

Purchase Option

Acquisition Option: Traditional Purchase
Cap Rate (%): Contact Lister
Net Operating Income: Contact Lister
Quick Glance
Listing ID: CL-California-12846
Status: Sold
Property Status: Bank/Corporate Owned
Building Status: Existing
Year Built: 2017
Building Size: 5,130.00 Sq Ft.
Total Rooms: 13
No of Bedrooms: 7
No of Bathrooms: 5
No of Half Bathrooms: 1
No of Total Units: 12
Lot Area: 5,662.00 Sq Ft.
No of Stories: 2
No of Parking: 2
No of Garages: N/a
Pool: No
Water Front: No
Roofing: Shingle
Attached Documents
  • Download | 1-Austin-Road-August-2024-Financial-Reports-pdf.pdf ( 1,903.56KB)
  • Download | 1-Final-Inspection-1-pdf.pdf ( 2,635.77KB)
  • Download | 2-Austin-Road-October-2024-Financial-Reports-pdf.pdf ( 2,379.44KB)
  • Download | 2-Final-Inspection-pdf.pdf ( 2,408.47KB)
  • Download | 208330-AllStoresList-16-8920241728421104450-xlsx.xlsx ( 56.30KB)
  • Download | 208330-Developments-17-8920241728421058874-pdf.pdf ( 77.39KB)
  • Download | 208330-MarketSnapshot-20-8920241728420960180-xlsx.xlsx ( 9.20KB)
  • Download | 208330-Transaction-8920241728421092762-xlsx.xlsx ( 8.49KB)
  • Download | Agenda-pdf.pdf ( 186.68KB)
  • Download | Appraisal-Land-960-000-183-South-Austin-Road-Manteca-CA-pdf.pdf ( 15,573.58KB)
  • Download | Appraisal-Stabilized-Value-183-South-Austin-Rd-2023-04-27-pdf.pdf ( 12,281.60KB)
  • Download | ARSSPolicy-1-pdf.pdf ( 8,165.81KB)
  • Download | Austin-Mini-Storage-Percolation-Calcs-with-Ground-Water-Data-pdf.pdf ( 4,935.55KB)
  • Download | Austin-Road-Managment-Summary-and-Rent-Roll-July-2024-pdf.pdf ( 1,574.82KB)
  • Download | Balance-Sheet-August-2024-pdf.pdf ( 123.13KB)
  • Download | Bank-Statements-pdf.pdf ( 2,368.63KB)
  • Download | Final-Print-Ready-2024-Eco-pdf.pdf ( 7,254.52KB)
  • Download | General-Ledger-pdf.pdf ( 3,299.69KB)
  • Download | HPSCAN-20241008215118251-2024-10-08-215206038-pdf.pdf ( 5,005.60KB)
  • Download | Lennar-Homes-Letter-of-Intent-pdf.pdf ( 1,718.06KB)
  • Download | Management-Summary-Report-Saturday-August-31st-2024-pdf.pdf ( 577.64KB)
  • Download | Occupancy-Statistics-Report-September-30th-2024-pdf.pdf ( 1,032.01KB)
  • Download | Occupied-History-September-30th-2024-pdf.pdf ( 416.01KB)
  • Download | Offering-Memorandum-Austin-Road-Self-Storage-October-2024-pdf.pdf ( 7,317.67KB)
  • Download | Prelim-FBDO-2401574-183-S-Austin-Road-Manteca-CA-pdf.pdf ( 1,190.04KB)
  • Download | Price-List-September-30th-2024-pdf.pdf ( 359.73KB)
  • Download | Profit-Loss-Statement-Dec-2023-to-August-2024-pdf.pdf ( 1,658.04KB)
  • Download | Profit-Loss-Statement-pdf.pdf ( 604.56KB)
  • Download | Property-Tax-Bill-1-pdf.pdf ( 361.12KB)
  • Download | Property-Tax-Bill-2-pdf.pdf ( 376.48KB)
  • Download | Sellers-Permit-pdf.pdf ( 778.93KB)
  • Download | Sept-Managment-History-pdf.pdf ( 1,318.79KB)
  • Download | Sept-Rent-Roll-pdf.pdf ( 2,154.20KB)
  • Download | SITE-PLANS-pdf.pdf ( 656.45KB)
  • Download | Suitability-Study-Austin-Rd-Manteca-22-282G-AK-KL-signed-pdf-update-binder-pdf.pdf ( 2,107.55KB)
  • Download | Title-Profile-pdf.pdf ( 206.71KB)
  • Download | Vacant-Unit-List-September-30th-2024-pdf.pdf ( 313.17KB)
  • Download | Yosemite-Square-Housing-Development-Information-docx.docx ( 14.92KB)
  • Download | Yosemite-Square-Improvement-Exhibit-pdf.pdf ( 569.23KB)
  • Download | Yosemite-Square-Subdivision-Project-pdf.pdf ( 97.33KB)
Listing Summary
Listed Below Appraisal! This rare Esplanade Avenue offering features two custom-built homes (both 2017) on a single lot—ideal for multi-generational living or income generation.
Complete Details
Year Build: 2017
Building Size: 5,130
Total Lot Area: 5,662
No. of Stories: 2
No. of Parking: 2
No. of Total Units: 12

Total Rooms: 0

No. of Bed Rooms: 7
No. of Bath Rooms: 5
No. of Half-Baths: 1
No. of Garages: 0
No. of Kitchen: 2
Property Current Status: Bank/Corporate Owned
Building Status: Existing
Heating and Cooling: Heating and Cooling
Furnished: No
Water Front: No
Pool: No
Roofing: Shingle
Detail Description

Listed Below Appraisal! This rare Esplanade Avenue offering features two custom-built homes (both 2017) on a single lot—ideal for multi-generational living or income generation. The front residence offers 4 spacious bedrooms, while the rear 3BD/2BA home (1,900 SF) is perfect as a rental, guest house, or in-law suite. Both homes are separated by a charming brick courtyard with a custom pergola, gas grill, and private off-street parking.

Enjoy timeless New Orleans charm with heart pine floors, coffered ceilings, and a farmhouse kitchen complete with marble countertops, reclaimed wood shelves, and a custom hood. The master suite includes a walk-in marble shower and antique wood accents. Located just steps from the French Quarter, this is a prime opportunity to live in luxury while creating value through long- or short-term rental (buyer to verify STR regulations). Owner financing available!

Additional Properties
Property Highlights
  • Adjacent to New Lennar Housing Development (797 Homes)
  • Trophy Property Constructed in 2022
  • All Drive Up Units
  • Advanced Security System With Motion Detectors
  • Average Household Income of $118K
  • Household Income $30K Higher than State Average
  • 75 Miles from Sacramento, San Francisco, & San Jose
  • Adjacent to Signalized Intersection
  • 85% Occupancy in Less than 24 Months of Opening
  • Below Market Rents
  • 3 Mile Population (56K+) | 5 Mile Population (104K+)
  • 100 5-Star Reviews on Google
Features
  • Acreage : 2.76
  • Number of Buildings : 14
  • Traffic Count : 16,871
Listing Address
Lister's other Properties
Address: PARCEL D Highway 17309 Hwy #16, , Franklinton Louisiana 70438
Listing ID: RL-Louisiana-25563
Listing Type: Residential
Category: Residential Type - Vacant Land
Status: Accepting Offers
Created On: 6/9/2025
Modified On: 6/9/2025
PARCEL D Highway 17309 Hwy #16, , Franklinton Louisiana                                                                                            70438
Address: PARCEL Highway 16 #A, , Franklinton Louisiana 70438
Listing ID: RL-Louisiana-25560
Listing Type: Residential
Category: Residential Type - Vacant Land
Status: Accepting Offers
Created On: 6/9/2025
Modified On: 6/9/2025
PARCEL Highway 16 #A, , Franklinton Louisiana                                                                                            70438
Address: PARCEL Highway 16 #B, , Franklinton Louisiana 70438
Listing ID: RL-Louisiana-25556
Listing Type: Residential
Category: Residential Type - Vacation Rental
Status: Accepting Offers
Created On: 6/9/2025
Modified On: 6/9/2025
PARCEL Highway 16 #B, , Franklinton Louisiana                                                                                            70438
Address: 36236 Sloat Rd, , Slidell Louisiana 70460
Listing ID: CL-Louisiana-25553
Listing Type: Commercial
Category: Industrial - Other
Status: Accepting Offers
Created On: 6/9/2025
Modified On: 6/9/2025
36236 Sloat Rd, , Slidell Louisiana                                                                                            70460
⚠ Disclaimer

LoopingCloud is a social listing portal that connects real estate professionals, service providers, buyers, and sellers. All property information, descriptions, availability, financial details, and any offerings under financial services, business services, and material services are provided by the respective lister or service provider and are not independently verified by LoopingCloud. While believed to be accurate, the information is provided “as is” without any representations, warranties, or guarantees of any kind. LoopingCloud does not endorse, warrant, or verify the quality, accuracy, or reliability of any property details or services provided through the portal. Interested parties are encouraged to independently verify all information and consult with qualified professionals before making any decisions.