• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • THE ISLES GROUP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • The wealth report
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • master trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON MAY 12 2025 AT 9:06 AM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

3243 45 Columbia St

san diego, CA 92103

$3,190,000

  • 5 BR
    3 BA
    APPROX. 2,419 SF

INTERESTED? LET'S CONNECT

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.

Details

2,419 Sq Ft

5,001 Sq Ft Exterior Space

Single Family Home

Built in 1938

MLS/Listing ID OC25048282

2 Stories

2 Units

Amenities & Features

Heating - Combination

Back Bay View

Listing Courtesy of TRI-STAR REALTY, CARL WUESTEHUBE - 800-621-4258

CRMLS

Source of Data: CALIFORNIA REGIONAL MULTIPLE LISTING SERVICE

Interested in 3243 45 Columbia St?