MLS Search

Forgot password Extend Verify Contact

3243 Columbia Street
OTHER San Diego 92103

$3,190,000
Residential beds: 5 baths: 3.0 2,419 sq. ft. built: 1938

Main Photo: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 1: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 2: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 3: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 4: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 5: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 6: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 7: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 8: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 9: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 10: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 11: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 12: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 13: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 14: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 15: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 16: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 17: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 18: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 19: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 20: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 21: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 22: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 23: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 24: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 25: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 26: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 27: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 28: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 29: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 30: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 31: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 32: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 33: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 34: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 35: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 36: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 37: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 38: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 39: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 40: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 41: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 42: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 43: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 44: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 45: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 46: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 47: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 48: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 49: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 50: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 51: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 52: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 53: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 54: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 55: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Photo 56: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
Status:
Active
Prop. Type:
Residential
MLS® Num:
306380006
Bedrooms:
5
Bathrooms:
3
Year Built:
1938
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 entranceideal 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 di
Total Floor Area:
2,419 sq. ft.
Price Per SqFt:
1318.73
Lot Size:
4,000-7,499 SF
Lot Size:
5,001 sq. ft.
Total Bedrooms:
5
Bedrooms:
5
Bathrooms:
3.0
Full Bathrooms:
3
Half Bathrooms:
0
Fireplace Details:
FP in Family Room, Patio/Outdoors
Architecture:
Ranch
Residential Style:
Detached
Stories:
2 Story
Num Stories:
2
Total Stories:
2
Entry Level Unit:
1
Residential Unit Location:
No Common Walls
Year Built:
1938
Total Parking Spaces:
2
Market Area:
OTHER
County:
San Diego
Community:
MISSION HILLS
Home Owner Fees:
0.0
Mello Roos Fee:
0.0
Terms:
Cash, Conventional
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 entranceideal 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 propertys central location ensures consistent demand from vacationers year-round. Why This Property? This home is more than just a residenceits 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 wont find another deal like this anywhere.
Elementary School:
San Diego Unified School District
Middle School:
San Diego Unified School District
High School:
San Diego Unified School District
Site Influences:
Curbs
Directions:
Laurel to Sassafras St (north) to Columbia St (east) Cross Street: Sassafras.
View:
Back Bay
Parcel Number:
4516120200
Heating:
Zoned Areas, Combination Heating
Heating fuel:
Natural Gas
Cooling:
Central Forced Air
Pool:
Private
Spa:
Private
Rooms:
Bedroom Entry Level, Den, Family Room, Walk-In Closet
Patio:
Deck, Patio
Water supply:
Public
Sewer Septic:
Public Sewer
Laundry Location:
Laundry Room
Sales Restrictions:
Standard
Floor finish:
Stone, Tile, Wood
Total Garage Spaces:
2
Assessments:
Unknown
Zoning:
RM-2-5
  • Photo 1: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 1 of 56
  • Photo 2: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 2 of 56
  • Photo 3: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 3 of 56
  • Photo 4: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 4 of 56
  • Photo 5: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 5 of 56
  • Photo 6: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 6 of 56
  • Photo 7: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 7 of 56
  • Photo 8: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 8 of 56
  • Photo 9: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 9 of 56
  • Photo 10: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 10 of 56
  • Photo 11: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 11 of 56
  • Photo 12: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 12 of 56
  • Photo 13: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 13 of 56
  • Photo 14: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 14 of 56
  • Photo 15: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 15 of 56
  • Photo 16: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 16 of 56
  • Photo 17: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 17 of 56
  • Photo 18: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 18 of 56
  • Photo 19: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 19 of 56
  • Photo 20: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 20 of 56
  • Photo 21: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 21 of 56
  • Photo 22: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 22 of 56
  • Photo 23: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 23 of 56
  • Photo 24: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 24 of 56
  • Photo 25: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 25 of 56
  • Photo 26: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 26 of 56
  • Photo 27: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 27 of 56
  • Photo 28: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 28 of 56
  • Photo 29: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 29 of 56
  • Photo 30: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 30 of 56
  • Photo 31: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 31 of 56
  • Photo 32: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 32 of 56
  • Photo 33: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 33 of 56
  • Photo 34: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 34 of 56
  • Photo 35: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 35 of 56
  • Photo 36: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 36 of 56
  • Photo 37: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 37 of 56
  • Photo 38: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 38 of 56
  • Photo 39: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 39 of 56
  • Photo 40: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 40 of 56
  • Photo 41: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 41 of 56
  • Photo 42: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 42 of 56
  • Photo 43: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 43 of 56
  • Photo 44: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 44 of 56
  • Photo 45: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 45 of 56
  • Photo 46: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 46 of 56
  • Photo 47: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 47 of 56
  • Photo 48: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 48 of 56
  • Photo 49: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 49 of 56
  • Photo 50: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 50 of 56
  • Photo 51: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 51 of 56
  • Photo 52: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 52 of 56
  • Photo 53: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 53 of 56
  • Photo 54: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 54 of 56
  • Photo 55: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 55 of 56
  • Photo 56: MISSION HILLS House for sale : 5 bedrooms : 3243 Columbia Street in San Diego
    Photo 56 of 56
Listed by Tri-Star Realty
Data was last updated April 25, 2025 at 07:10 PM (UTC)
Area Statistics
Listings on market:
44,343
Avg list price:
$705,000
Min list price:
$100
Max list price:
$150,000,000
Avg days on market:
51
Min days on market:
1
Max days on market:
2,818
Avg price per sq.ft.:
$445.13
These statistics are generated based on the current listing's property type and located in OTHER. Average values are derived using median calculations.
This information is deemed reliable but not guaranteed. You should rely on this information only to decide whether or not to further investigate a particular property. BEFORE MAKING ANY OTHER DECISION, YOU SHOULD PERSONALLY INVESTIGATE THE FACTS (e.g. square footage and lot size) with the assistance of an appropriate professional. You may use this information only to identify properties you may be interested in investigating further. All uses except for personal, non-commercial use in accordance with the foregoing purpose are prohibited. Redistribution or copying of this information, any photographs or video tours is strictly prohibited. This information is derived from the Internet Data Exchange (IDX) service provided by San Diego Multiple Listing Service, Inc. Displayed property listings may be held by a brokerage firm other than the broker and/or agent responsible for this display. The information and any photographs and video tours and the compilation from which they are derived is protected by copyright. Compilation © 2025 San Diego Multiple Listing Service, Inc.