• Facebook
  • Twitter
  • Instagram
  • Pinterest
  • LinkedIn
  • Blog
Phone714-745-2708
Login or sign up for new accountLogin / Register
Email Our TeamEmail Us
  • Search Listings
    • Residential
    • Lease
    • Commercial
  • Our Listings
  • Previous Sales
  •   Local
    • Anaheim
    • Orange
    • North Tustin
    • Orange Park Acres
    • Santa Ana
    • Yorba Linda
    • Tustin
    • Fullerton
  •   Buyers
    • Vesting
    • Buyer's and Seller's Guide to Title and Escrow
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • What do you want in a home?
    • Finding your home
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • New Sellers Guide
    • Sellers Seminar
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Closing Services
    • Home Financing
    • Relocation
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PINNACLE
  •     About
    • About Us
    • Leadership Team
    • Globally Respected
    • Diversity & Inclusion
    • The Charitable Foundation
    • Doyle
    • Agents Only
  • Our Team
  •     My Links
    • Buyer And Seller Guide
    • Seniors
    • Senior Communities in Orange County
  • Blog
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
3243 45 Columbia Street San Diego, CA 92103
$3,190,000 5 beds, 3 baths
2, 419 sqft
Save My Notes
 
The Keaty Team

View Team Members

Interested in This Property? Your message will be sent to Kevin.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Agent Remarks

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.

Listing Details

Property type: Single Family Residence (Single Family)
Status: Active
MLS# OC25048282
List price is $3,190,000
HOA Fee is $0.00
Beds: 5
Baths: 3 (3 full)
Family Room,Outside fireplaces
Built in 1938
2,419 sqft
2 stories
0.11 acres
Lot size: 0.1148
Subdivision: Mission Hills
County: San Diego
Property style: Ranch
Zoning: RM-2-5
Interior features: Bedroom on Main Level,Walk-In Closet(s)
Lot description: Back Yard,Front Yard
Heating/cooling: Central Air
Heating description: Combination,Natural Gas,Zoned
MLS area: 92103 - Mission Hills

Last Updated: 3/10/2025

 Find more San Diego homes and real estate

 Find more homes in 92103 zip code

This listing belongs to the 92103 - Mission Hills MLS area

 Find more homes in the Mission Hills subdivision

The style of this listing is Ranch.
Find more Ranch style homes for sale

Lat/Long: 32.737553, -117.174759.
Find nearby listings


Listing Agent: Carl Wuestehube
Lic#: 01276603
Office Name: Tustin

Area Map

Nearby Schools

No schools were found in the area

Area Overview

Total population of , which has changed by % since 1990.
The median age of the population is , while the median age of dwellings is .
Out of households, are families.

Community Characteristics:

Occupancy Type

White/Blue Collar Jobs

Population by Gender

Hispanic/Non-Hispanic Population

Compared to National:

  • Search
    • My Active Listings
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Vesting
    • Buyer's and Seller's Guide to Title and Escrow
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • What do you want in a home?
    • Finding your home
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • New Sellers Guide
    • Sellers Seminar
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • About Us
    • Leadership Team
    • Globally Respected
    • Diversity & Inclusion
    • The Charitable Foundation
    • Doyle
    • Agents Only
  • My Links
    • Buyer And Seller Guide
    • Seniors
    • Senior Communities in Orange County
  • Blog
  • Our Team
The Keaty Team
Lic#: 01276603

View Team Members


Tustin Office
18302 Irvine Blvd, Suite 240
Tustin, CA 92780
  • Facebook
  • Twitter
  • Instagram
  • Pinterest
  • LinkedIn
  • Blog

© 2025 Berkshire Hathaway HomeServices California Properties (BHHSCP) is a member of the franchise system of BHH Affiliates LLC. BHHS and the BHHS symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. BHH Affiliates LLC and BHHSCP do not guarantee accuracy of all data including measurements, conditions, and features of property. Information is obtained from various sources and will not be verified by broker or MLS. Buyer is advised to independently verify the accuracy of that information.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status