Mission Hills Detached

Forgot password Extend Verify Contact

3243 Columbia Street #45
San Diego San Diego 92103

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

Main Photo: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 1: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 2: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 3: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 4: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 5: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 6: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 7: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 8: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 9: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 10: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 11: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 12: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 13: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 14: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 15: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 16: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 17: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 18: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 19: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 20: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 21: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 22: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 23: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 24: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 25: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 26: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 27: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 28: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 29: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 30: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 31: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 32: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 33: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 34: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 35: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 36: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 37: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 38: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 39: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 40: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 41: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 42: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 43: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 44: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 45: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 46: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 47: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 48: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 49: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 50: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 51: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 52: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 53: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 54: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 55: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
Photo 56: House for sale : 5 bedrooms : 3243 Columbia Street #45 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
Property Sub Type:
Detached
County Or Parish:
San Diego
Name of Complex/Subdivision:
MISSION HILLS
Total Building Area:
2,419 sq. ft.
Total Floor Area:
2,419 sq. ft.
Total Bedrooms:
5
Bathrooms:
3
Full Bathrooms:
3
Half Bathrooms:
0
Fireplace Details:
FP in Family Room, Patio/Outdoors
Architecture:
Ranch
Stories:
2 Story
Num Stories:
2
Total Stories:
2
Entry Level:
1
Year Built:
1938
Age (in years):
87 year(s)
Home Owner Fees:
$0
Mello Roos Fee:
$0
Mello Roos Fee Frequency:
Year
Terms:
Cash, Conventional
Laurel to Sassafras St (north) to Columbia St (east) Cross Street: Sassafras.
Elementary School District:
San Diego Unified School Distric
Junior High School District:
San Diego Unified School Distric
High School District:
San Diego Unified School Distric
Site Influences:
Curbs
View:
Back Bay
Special Listing Conditions:
Standard
Lot Size:
5,001 sq. ft.
Parcel Number:
4516120200
Total Parking Spaces:
2
Total Garage Spaces:
2
Heating:
Zoned Areas, Combination Heating
Heating fuel:
Natural Gas
Cooling:
Central Forced Air
Pool Features:
Private
Spa Features:
Private
Patio And Porch Features:
Deck, Patio
Interior Walls:
No Common Walls
Water supply:
Public
Sewer Septic:
Public Sewer
Floor finish:
Stone, Tile, Wood
Assessments:
Unknown
Zoning:
RM-2-5
  • Photo 1: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 1 of 56
  • Photo 2: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 2 of 56
  • Photo 3: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 3 of 56
  • Photo 4: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 4 of 56
  • Photo 5: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 5 of 56
  • Photo 6: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 6 of 56
  • Photo 7: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 7 of 56
  • Photo 8: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 8 of 56
  • Photo 9: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 9 of 56
  • Photo 10: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 10 of 56
  • Photo 11: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 11 of 56
  • Photo 12: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 12 of 56
  • Photo 13: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 13 of 56
  • Photo 14: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 14 of 56
  • Photo 15: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 15 of 56
  • Photo 16: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 16 of 56
  • Photo 17: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 17 of 56
  • Photo 18: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 18 of 56
  • Photo 19: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 19 of 56
  • Photo 20: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 20 of 56
  • Photo 21: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 21 of 56
  • Photo 22: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 22 of 56
  • Photo 23: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 23 of 56
  • Photo 24: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 24 of 56
  • Photo 25: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 25 of 56
  • Photo 26: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 26 of 56
  • Photo 27: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 27 of 56
  • Photo 28: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 28 of 56
  • Photo 29: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 29 of 56
  • Photo 30: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 30 of 56
  • Photo 31: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 31 of 56
  • Photo 32: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 32 of 56
  • Photo 33: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 33 of 56
  • Photo 34: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 34 of 56
  • Photo 35: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 35 of 56
  • Photo 36: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 36 of 56
  • Photo 37: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 37 of 56
  • Photo 38: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 38 of 56
  • Photo 39: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 39 of 56
  • Photo 40: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 40 of 56
  • Photo 41: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 41 of 56
  • Photo 42: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 42 of 56
  • Photo 43: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 43 of 56
  • Photo 44: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 44 of 56
  • Photo 45: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 45 of 56
  • Photo 46: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 46 of 56
  • Photo 47: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 47 of 56
  • Photo 48: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 48 of 56
  • Photo 49: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 49 of 56
  • Photo 50: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 50 of 56
  • Photo 51: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 51 of 56
  • Photo 52: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 52 of 56
  • Photo 53: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 53 of 56
  • Photo 54: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 54 of 56
  • Photo 55: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 55 of 56
  • Photo 56: House for sale : 5 bedrooms : 3243 Columbia Street #45 in San Diego
    Photo 56 of 56
Listed by Tri-Star Realty
Data was last updated July 31, 2025 at 03:10 AM (UTC)
Area Statistics
Listings on market:
3,085
Avg list price:
$899,000
Min list price:
$69,000
Max list price:
$16,900,000
Avg days on market:
43
Min days on market:
1
Max days on market:
1,923
Avg price per sq.ft.:
$690.29
These statistics are generated based on the current listing's property type and located in San Diego. Average values are derived using median calculations. This data is not produced by the MLS® system.
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.