BuySellBlogBrowse Listings

3243 45 Columbia StreetSan Diego, CA 92103

For Sale

$2,975,000

Smart Buyer Rebate $29,750

How often do you get an opportunity to have your cake and eat it too? Check out this one-of-a-kind opportunity to own a luxury resort in the middle of the city AND earn a hefty six figure income … guaranteed. (new par)

Turnkey Luxury Vacation Rental Villa with Guaranteed $300,000 Annual Gross Income – Incredibly Rare Opportunity!

Discover the ultimate investment in San Diego with this stunning 5-bedroom, 3-bath villa, already a top-performing licensed vacation rental. Nestled in the heart of the city, this property offers a seamless blend of luxury living and proven profitability, making it perfect for investors or those seeking a dream home with income and tax saving potential.

Guaranteed Income: Keep the current management company and enjoy a guaranteed gross income of $300,000 per year for two years. The property comes fully furnished with high end decor, is licensed by the city of San Diego, and is designated as a “Guest Favorite” on Airbnb with average review score of 4.94/5.0 (https://www.airbnb.com/rooms/45786328).

Luxury Features include: Heated pool and hot tub with waterfall, Stainless Steel Japanese soaking tub, Game room with pool table, arcade, skeeball, darts, and more, and top of the line furnishings throughout.

Panoramic observation deck with breathtaking 230 degree views of downtown San Diego, the harbor, and beyond

Separate Studio Apartment: Includes a kitchen, bath, and private entrance—ideal for added privacy or additional rental income (this unit is rented along with the main home, but can be used by owner as needed).

Prime Location
Located within walking distance to iconic attractions like Balboa Park, Little Italy, and the San Diego Zoo, and just minutes from beaches, downtown, and Coronado Island. This property’s central location ensures consistent demand from vacationers year-round.

Why This Property?
This home is more than just a residence—it’s a thriving business opportunity. With an established Airbnb presence and rave reviews (4.94/5 stars), it offers both luxury living and reliable cash flow.



Based on the current P&L the property offers a 5.2% CAP Rate, among the strongest of any property currently listed in in San Diego. You will also enjoy tax benefits that come with accelerated depreciation on short term rental FF&E. Combine that with a 2-year revenue guarantee, and won’t find another deal like this anywhere.

Listed by Carl Wuestehube

·

License #00634943

·

Tri-Star Realty

·

714-791-6026

Last updated September 15, 2025

·

Source: CRMLS #OC25199204

Listing Facts

  • TypeSingle-family
  • NeighborhoodMiddletown
  • Bedrooms5
  • Bathrooms3
  • Days on Prevu77
  • Size2,419 sqft
  • Price per sqft$1,230

Amenities

  • Private Outdoor Space
  • Air Conditioning
  • Parking
  • Swimming Pool

Location

Mortgage Calculator

Listing History

10/29/2025
Status changed to Active
$2,975,000
10/21/2025
Status changed to Removed from Feed
$2,975,000
10/18/2025
Status changed to Active
$2,975,000
10/17/2025
Status changed to Removed from Feed
$2,975,000
10/05/2025
Status changed to Active
$2,975,000
10/04/2025
Status changed to Removed from Feed
$2,975,000
09/21/2025
Status changed to Active
$2,975,000
09/20/2025
Status changed to Removed from Feed
$2,975,000
09/10/2025
Status changed to Active
$2,975,000
09/09/2025
Status changed to Removed from Feed
$2,975,000
09/08/2025
Status changed to Active
$2,975,000
09/06/2025
Status changed to Removed from Feed
$2,975,000
09/04/2025
Listed by Tri-Star Realty
$2,975,000

Property Details for 3243 45 Columbia Street

Association

Amenities

  • Community Features: Curbs

Exterior

Construction

  • Number Of Units Total: 2
  • Stories: 1
  • Stories Total: 2
  • Structure Type: House
  • Year Built: 1938
  • Architectural Style: Ranch
  • Common Walls: No Common Walls
  • Entry Level: 1
  • Entry Location: 1

Features

  • Patio And Porch Features: Deck, Patio
  • Pool Features: Private
  • Pool Private: Yes
  • View: Back Bay

Measurements

  • Lot Features: Back Yard, Front Yard
  • Lot Size Acres: 0.11
  • Lot Size Area: 5,001
  • Lot Size Source: Assessor
  • Lot Size Square Feet: 5,001
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: 4516120200

Interior

Features

  • Fireplace Features: Family Room, Outside
  • Fireplace: Yes
  • Flooring: Stone, Tile, Wood
  • Interior Features: Bedroom On Main Level, Walk-In Closet(s)
  • Spa Features: Private
  • Spa: Yes

Measurements

  • Living Area: 2,419
  • Living Area Source: Owner
  • Living Area Units: Square Feet

Rooms

  • Bathrooms Full: 3
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 5
  • Main Level Bathrooms: 3
  • Main Level Bedrooms: 5

Other

Location

  • Subdivision Name: Mission Hills
  • Tax Block: 128
  • Tax Lot: 3

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Garage: Yes
  • Parking Total: 2

Schools

High School

  • High School District: San Diego Unified

Utilities

Equipment

  • Cooling: Central Air
  • Has Cooling: Yes
  • Heating: Combination, Natural Gas, Zoned
  • Has Heating: Yes
  • Laundry Features: Laundry Room
  • Sewer: Public Sewer
  • Water Source: Public

Based on information from California Regional Multiple Listing Service, Inc. and/or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by Prevu or the MLS. Information is provided exclusively for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.