Ranch

3243 45 Columbia Street

San Diego , CA 92103

MLS#: OC25199204

$2,975,000

Status: Active
Listing number: OC25199204
Listing provided by: Tri-Star Realty
Listing agent phone: None
Last update: 16 hours ago
New on site 2 days ago
Browse Properties
Mission Hills - Residential

Property

Beds

5

Full Baths

3

1/2 Baths

None

Year Built

1938

Sq.Footage

2,419

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.

Features & Amenities

Interior

  • Other Interior Features

    Walk-In Closet(s)

  • Total Bedrooms

    5

  • Bathrooms

    3

  • Cooling YN

    YES

  • Cooling

    Central Air

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Natural Gas, Zoned

  • Main Level Bedrooms

    5

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    2

  • Construction Materials

    Stone

  • Parking

    Attached

  • Patio and Porch Features

    Deck, Patio

  • Pool

    Yes

  • Pool Features

    Private

Area & Lot

  • Lot Features

    Back Yard, Front Yard

  • Lot Size(acres)

    0.1148

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Ranch

Price

  • Sales Price

    $2,975,000

  • Sq. Footage

    2, 419

  • Price/SqFt

    $1,229

HOA

  • Association

    NO

School District

  • Elementary School

    N/A

  • Middle School

    N/A

  • High School

    N/A

Property Features

  • Stories

    2

  • Senior Community YN

    NO

  • Sewer

    Public Sewer

  • Tax Lot

    3

  • Water Source

    Public

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

San Diego

Elementary School

Middle School

High School

Listing Courtesy of Carl Wuestehube , Tri-Star Realty

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent LinaMirza

FOUNDER

LinaMirza

Call Lina today to schedule a private showing.

(818) 321-0175

Lina@theosrealty.com


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
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.

3243 45 Columbia Street

Message successfully sent.

What would you like to know?

Related Properties

New on site 1 day ago
Presenting an exceptional, 3693sf property with private, sunset canyon views! A gorgeous and expansive, western-facing pool home with Owned Solar for the most discerning buyers! A chef's dream remodeled gourmet kitchen with newer, white shaker cabinets and grey quartz countertops. Top of the line stainless steel appliances include a deluxe Sub Zero refrigerator and Viking oven and range. Extra cabinets and countertops, wine rack, beverage station and wine fridge. The open kitchen flows seamlessly into the sun-bathed living room with multiple windows that bring in the light and views. An entertainer’s yard has numerous spaces to enjoy: In addition to the sparkling pool with waterfalls and a slide, there is a putting green, gas fire pit with bench seating and a lovely gazebo with TV and heaters, plus a built-in bbq with fridge and sink. The convenient ground floor bedroom has a full bath ensuite. A laundry room, half bath, 3-car garage with Tesla charger, formal dining and family room with pool table completes the downstairs. A stunning two-story vaulted ceiling entry and updated modern metal railings lead upstairs to the well-appointed primary retreat which has a versatile flex space, beautiful backyard views and walk-in closets. The luxurious primary bathroom has custom cabinetry, dual sinks, a marble vanity, double-headed shower with gorgeous tile accents and a stylish stand alone tub. The additional 3 upstairs bedrooms are each spacious and share an updated bathroom with dual sinks, marble accents and tiled shower (complete with a laundry chute :) Other notable features include a Ring camera doorbell, HVAC with an energy-efficient Ecobee thermostat, Solar Panels for both the home and pool, built-in surround sound speakers in the living room, remote controlled pool cover, sun shades, extra storage under the stairs and in the primary suite. Located in the desirable Poway Unified School District. This is luxurious California indoor/outdoor living at it's best!
#NDP2508700

San Diego

12348 Dormouse Road

5 Beds

3 Baths

3,693 Sq.Ft.

$2,499,000

MLS#: NDP2508700

New on site 2 days ago
Views of the Marina, Cabrillo Point, Coronado bridge, Downtown Skyline and beyond. Welcome to La Playa, Point Loma! This timeless coastal contemporary home is a masterpiece of light and space. With 3 bedrooms, 3.5 bathrooms, and 2,422 sq. ft. of open, airy living, it effortlessly blends mid-century modern elements with updated, sophisticated finishes. Natural light floods every corner, inviting the outdoors in and making the ever-changing skyline part of your daily living experience. Step outside and you’re just blocks from La Playa beach, the San Diego Yacht Club, and all the charm of Point Loma Village—boutique coffee shops, eateries, and bayside strolls are just moments away. Whether you’re entertaining on the patio with the city as your backdrop or soaking in the quiet beauty of a morning sunrise over the water, this home offers a living experience that can’t be captured in photos—only felt in person.
#250038126SD

San Diego

885 Armada Ter

3 Beds

3 Baths

2,422 Sq.Ft.

$2,890,000

MLS#: 250038126SD

New on site 3 days ago
Nestled in the prestigious community of The Breakers, this exceptional residence offers a rare opportunity to enjoy refined living in one of Carmel Valley’s most desirable cul-de-sac locations. The expansive front yard sets a gracious tone, while the beautifully landscaped backyard is an entertainer’s dream—featuring a sparkling pool, built-in barbecue, charming gazebo, vegetable garden, and generous space for gatherings. Inside, the home boasts of soaring ceilings and abundant natural light that enhances the spacious family and dining areas, creating an inviting and warm ambiance. Situated along a serene canyon, the property offers enhanced privacy. Additional highlights include solar energy. Enjoy one of Carmel Valley's most sought-after communities with close proximity to top-rated schools, scenic trails, shopping, dining, and major freeways.
#NDP2508308

San Diego

10794 Spur Point Court

5 Beds

3 Baths

3,470 Sq.Ft.

$2,900,000

MLS#: NDP2508308

New on site 3 days ago
An Exceptionally Rare Coastal Retreat This thoughtfully updated home captures the essence of coastal living with a perfect blend of timeless character and refined comfort. Bathed in natural light and ocean breezes, every space feels warm, inviting, and designed for both everyday living and unforgettable entertaining. The heart of the home is a chef’s gourmet kitchen, featuring a 6-burner top-of-the-line gas stove, stainless steel appliances, a deep farmhouse sink, and generous counter space, ideal for preparing holiday feasts or casual gatherings with friends. Wide-open living areas flow seamlessly to two expansive decks, where ocean views set the stage for morning coffee, sunsets, and year-round enjoyment. The primary suite is a true sanctuary, offering panoramic ocean views, a spa-like bath with soaking tub, and an expansive walk-in closet. Additional upgrades throughout, including new floors, showcase the home’s elevated design. Enjoy this iconic surf spot and walking/running trails just steps from Sunset Cliffs. This residence offers a lifestyle where community, comfort, and the coast come together in one extraordinary home.
#250038011SD

San Diego

4328 Piedmont Dr

4 Beds

3 Baths

3,508 Sq.Ft.

$3,199,999

MLS#: 250038011SD

New on site 3 days ago
Some residences are built to impress. Residence 801 was created to inspire. Located on the Northeast corner of the 8th floor of Bankers Hill’s most distinctive boutique address, 41West, this residence opens wide beneath 10-foot ceilings and retracting NanaWalls that frame San Diego’s most celebrated views: Balboa Park’s California Tower, the buzz of Bankers Hill and even a sliver of the Pacific from your private corner terrace. The arrival is dramatic, double doors open into a living space grand enough for a grand piano, with morning light streams across the room. Every detail elevates daily life: Vantage-controlled lighting that sets the mood with a single touch, automatic shades that vanish into silence, and a concealed 110-inch screen that transforms the room into a private cinema. The “music room” speaks to the current owner’s love of vinyl, yet its flexibility invites reinvention, a library, study, or hidden pantry. The kitchen is a dream, outfitted with Miele appliances (steam oven, five-burner gas cooktop, built-in wine cabinet), Italian cabinetry, and filtered water. Retreat to the primary suite, where park views, a spa-inspired bath with soaking tub and oversized shower, and a custom walk-in closet redefine comfort. A second bedroom is equally impressive and offers its own park-framed views. *See Supplement for More Details* Only four homes share this floor, and just 41 in the building, true boutique living. The lobby makes a statement, the hallways a gallery, and there is true magic outside with the cultural heartbeat of Balboa Park, Bankers Hill’s dining and café scene, and a neighborhood steeped in history yet alive with energy. 2 side by side parking spaces, storage unit and EV charging station. Residence 801 at 41West — as rare as it is refined. MARKETING VIDEO IN VIRTUAL LINK!
#250038066SD

San Diego

2604 5th Ave #801

2 Beds

2 Baths

2,247 Sq.Ft.

$2,729,000

MLS#: 250038066SD

New on site 4 days ago
An exceptional Sonoma home tucked away at the very end of a quiet cul-de-sac in one of Carmel Valley’s most desirable neighborhoods. Ideally located just minutes from award-winning, top-rated schools, this property also offers quick access to Del Mar Highlands Town Center, One Paseo’s vibrant dining and shopping, and nearby freeways for an easy coastal commute. The expansive backyard is designed with resort-style amenities to make everyday living feel like a vacation—enjoy a solar-heated pool w/ slide, and spa, evenings around the fire pit, and a built-in grill area that make entertaining effortless year-round. Inside, the residence blends comfort, functionality, and timeless design. A family-style kitchen flows seamlessly into casual living areas, while formal living and dining rooms accented with rich hardwood floors provide space for gatherings. The highly desirable floor plan includes a full bedroom and bathroom downstairs, perfect for guests, in-laws, or a private office. Upstairs, four generously sized bedrooms create flexibility for family, work, or hobbies. Lovingly maintained, this home has been thoughtfully updated with a newer roof, dual A/C units, and modern appliances, ensuring peace of mind. Whether relaxing poolside, gathering around the fire pit, or exploring nearby shopping, dining, and coastal amenities, this home truly captures the essence of Carmel Valley living. Don’t miss this rare opportunity to own a residence that blends timeless design, and an unbeatable location.
#250037910SD

San Diego

4919 Concannon Ct

5 Beds

4 Baths

3,516 Sq.Ft.

$2,575,000

MLS#: 250037910SD

New on site 4 days ago
Nestled in the coveted Ocean Beach Highlands, this beautifully remodeled 3-bedroom with a versatile office that can easily be converted into a 4th bedroom, 3-bathroom home offers panoramic ocean views from most rooms. The thoughtfully designed layout maximizes the stunning vistas, with expansive decks perfect for outdoor entertaining or simply enjoying the serene coastline. The spacious private backyard is an ideal retreat, featuring a lush grass area, large below ground spa, and ample space for relaxation or recreation. This home also boasts a brand-new two-car garage and sits on a large corner lot, offering both privacy and potential. The 132' foot ocean facing corner lot may allow for the possibility of multiple ocean view ADUs, providing future investment opportunities. Inside, every room has been meticulously updated and showcases high-end finishes. From the open-concept living spaces to the well-appointed kitchen and modern bathrooms, this home is a perfect blend of style and comfort. Tankless water heater and leased solar panels minimize the energy costs. Whether you're enjoying the coastal breezes from the deck or exploring the potential for additional development, this home offers an unparalleled combination of luxury, location, and lifestyle.
#250037975SD

San Diego

4506 Point Loma Avenue

3 Beds

3 Baths

2,659 Sq.Ft.

$2,999,999

MLS#: 250037975SD

New on site 4 days ago
Welcome to 5353 Westknoll Drive, a rare opportunity in the sought-after Castle Hills neighborhood of Pacific Beach. Situated on the west side of Soledad Mountain, this expansive 4-bedroom, 2.5-bath residence offers nearly 3,000 square feet of living space on an elevated and private lot along a quiet street of established hillside homes. On the market for the first time in over 50 years, the home has been meticulously cared for and presents a truly special chance to make it your own. Designed with a traditional floor plan, the home features large living areas, generous bedrooms, and multiple gathering spaces providing ample room for family, entertaining, and a comfortable coastal lifestyle. Modern amenities include paid-off solar energy and a home security system, offering both efficiency and peace of mind. A massive 3-car garage provides exceptional parking, storage, and flexibility that is rarely found in this neighborhood. Outdoors, enjoy pristine and picturesque landscaping, private spaces for relaxing or entertaining, and serene hillside views, along with ocean views from the second level.
#250037902SD

San Diego

5353 Westknoll Dr

4 Beds

2 Baths

2,695 Sq.Ft.

$2,495,000

MLS#: 250037902SD

Experience the perfect balance of luxury and functionality in this beautifully designed 4-bedroom, 3-bathroom home, ideally situated in the highly sought-after Del Cerro community. From soaring ceilings to high-end finishes, this home is thoughtfully crafted for both comfortable living and effortless entertaining. The spacious family room features a custom-built entertainment center and bar—perfect for hosting guests or enjoying cozy nights in. At the heart of the home is a chef-inspired kitchen, complete with premium appliances, an expansive island ideal for gatherings, and a walk-in pantry. Whether you're preparing a quiet dinner or celebrating with friends, this space rises to the occasion. The serene primary suite offers a private balcony with sweeping views, a generous walk-in closet, and a spa-like bathroom with a soaking tub—your personal retreat after a long day. Step outside to a resort-style backyard designed for relaxation and entertainment alike. Enjoy a heated pool and spa with a waterfall feature, a built-in fire pit, and plenty of space for dining or lounging under the stars. Eco-conscious features include 36 solar panels and 3 backup batteries for efficient energy use, while the three-car garage comes equipped with epoxy flooring and an two EV charging stations—offering both style and sustainability. Located just minutes from Lake Murray and close to major freeways, shopping, grocery stores, and top-rated schools, this home is the ideal blend of comfort, convenience, and luxury. You dont want to miss the opportunity to call this place home.
#PTP2506084

San Diego

7056 Del Cerro Boulevard

4 Beds

3 Baths

3,784 Sq.Ft.

$2,450,000

MLS#: PTP2506084

- property

Send a message

Message successfully sent.

Your message

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to receive some additional information on this specific property or similar properties?

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here