$307,500
SOLD FEB 25, 2026

718 Sycamore Ave Unit 195 Vista, CA 92083

Shadowridge Neighborhood
3 Beds
2 Baths
1,512 Sq Ft
4,500 Sq Ft Lot

Sale Details

Date Sold: February 25, 2026

$203 Per Sq Ft

9% Below List Price

129 Days on Market

Highlights

  • Heated In Ground Pool
  • Primary Bedroom Suite
  • Open Floorplan
  • Active Adult
  • View of Trees or Woods
  • Property is near public transit

About This Home

As of February 2026

Stunning brand-new home with PANORAMIC VIEW plus 1 year free space rent! You will love the open floor plan with tall ceilings and tons of natural light. The gourmet kitchen features a quartz topped island with seating and a full suite of brand-new stainless-steel appliances! The spacious great room features clerestory windows - a dramatic architectural feature. The primary suite has it all with a huge walk-in closet, extra tall windows, and a deluxe bathroom complete with a walk-in shower, dual sink vanity, and pretty built-in linen cabinets. You also get two additional spacious bedrooms and a guest bath with convenient tub/shower combo. Outside you will love the extra-large covered deck facing the expansive view. Abundant upgrades including, 2” blinds, wood-look solid surface flooring throughout, ceiling fans in all bedrooms, dual pane windows, extra-long carport, and so much more! This home combines style, functionality, and privacy all in one perfect package! Must See to appreciate. Call now! #17600PHA103510AB

Last Agent to Sell the Property

Sean Feeney

Sean Feeney, Broker Brokerage Email: s.feeney@pacifichomes.net License #01117041 Listed on: 10/03/2025

Last Buyer's Agent

Sean Feeney

Sean Feeney, Broker Brokerage Email: s.feeney@pacifichomes.net License #01117041 Listed on: 10/03/2025

Property Details

Home Type

  • Manufactured Home

Year Built

  • Built in 2025 | Under Construction

Lot Details

  • 4,500 Sq Ft Lot
  • Partially Fenced Property
  • Landscaped
  • Rectangular Lot
  • Front Yard Sprinklers
  • Density is up to 1 Unit/Acre
  • Land Lease of $1,200 per month

Property Views

  • Woods
  • Bluff
  • Valley
  • Neighborhood

Home Design

  • Entry on the 1st floor
  • Turnkey

Interior Spaces

  • 1,512 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Built-In Features
  • High Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Double Pane Windows
  • Low Emissivity Windows
  • Blinds
  • Family Room Off Kitchen
  • Living Room
  • Center Hall
  • Vinyl Flooring

Kitchen

  • Open to Family Room
  • Gas Oven or Range
  • Free-Standing Range
  • Range Hood
  • Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Built-In Trash or Recycling Cabinet
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • 2 Full Bathrooms
  • Quartz Bathroom Countertops
  • Dual Vanity Sinks in Primary Bathroom
  • Soaking Tub
  • Bathtub with Shower
  • Separate Shower
  • Exhaust Fan In Bathroom

Laundry

  • Laundry Room
  • Gas Dryer Hookup

Parking

  • 2 Parking Spaces
  • 2 Attached Carport Spaces
  • Parking Available

Outdoor Features

  • Heated In Ground Pool
  • Covered Patio or Porch
  • Rain Gutters

Location

  • Property is near public transit
  • Suburban Location

Mobile Home

  • Mobile home included in the sale
  • Mobile Home is 27 x 56 Feet

Utilities

  • Central Heating
  • Water Heater

Listing and Financial Details

  • Assessor Parcel Number 2171227000
  • Seller Considering Concessions

Community Details

Overview

  • Active Adult
  • No Home Owners Association
  • GRANDVIEW TERRACE | Phone (760) 727-1830
  • Foothills

Recreation

  • Community Pool
  • Park
  • Hiking Trails
  • Bike Trail

Pet Policy

  • Pets Allowed

Property Details

Home Type

Manufactured Home

Year Built

Built in 2025 | Under Construction

Lot Details

4,500 Sq Ft Lot

Listing Details

  • Assessments: Yes
  • Mobile Home Remains: Yes
  • Mobile Length: 56
  • Mobile Width: 27
  • Park Manager Name: Mr. Manager
  • Park Manager Phone: 760-727-1830
  • Park Name: GRANDVIEW TERRACE
  • View: Yes
  • Property Condition: Under Construction, Turnkey
  • Property Type: Manufactured In Park
  • Parcel Number: 2171227000
  • Year Built: 2025
  • AgentOnly_SellerConsiderConcessionYN: Yes
  • Special Features: NewHome
  • Property Sub Type: MobileManufactured

Interior Features

  • Living Area: 1512.00 Square Feet
  • Interior Amenities: Built-in Features, High Ceilings, Ceiling Fan(s), Pantry, Recessed Lighting, Open Floorplan
  • Stories: 1
  • Flooring: Vinyl
  • Appliances: Yes
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Entry Level: 1
  • Levels: One
  • Price Per Square Foot: 209.99
  • Room Type: Walk-In Closet, Primary Bedroom, Laundry, All Bedrooms Down, Main Floor Primary Bedroom, Kitchen, Center Hall, Living Room, Main Floor Bedroom, Primary Suite, Primary Bathroom
  • Window Features: Double Pane Windows, Blinds, Low Emissivity Windows
  • Bathroom Features: Soaking Tub, Quartz Counters, Shower In Tub, Exhaust Fan(s), Separate Tub And Shower, Double Sinks In Primary Bath, Bathtub, Shower
  • Room Kitchen Features: Kitchen Open To Family Room, Kitchen Island, Built-In Trash/Recycling

Exterior Features

  • Patio: Yes
  • Exterior Features: Rain Gutters
  • View: Trees/Woods, Neighborhood, Valley
  • Fence: Yes
  • Fencing: Partial
  • Patio And Porch Features: Covered, Porch
  • Pool Features: In Ground, Community, Heated
  • Pool Private: No
  • Spa: No

Garage/Parking

  • Carport Spaces: 2.00
  • Parking: Yes
  • Parking Features: Attached Carport
  • Total Parking Spaces: 2.00

Utilities

  • Utilities: Natural Gas Available, Electricity Connected
  • Sprinklers: Yes
  • Heating: Yes
  • Laundry: Yes
  • Appliances: Water Heater, Gas Cooking, Disposal, Microwave, Refrigerator, Free-Standing Range, Range Hood, Ice Maker, Dishwasher
  • Heating Type: Central
  • Laundry Features: Gas Dryer Hookup

Condo/Co-op/Association

  • Association: No
  • Senior Community: Yes
  • Community Features: Biking, Hiking, Foothills, Suburban, Park

Lot Info

  • Land Lease: Yes
  • Land Lease Amount: 1200.00
  • Land Lease Amount Frequency: Monthly
  • Lot Features: Sprinklers In Front, Landscaped, Rectangular Lot, 0-1 Unit/Acre, Bluff, Near Public Transit
  • Lot Size Sq Ft: 4500.00
  • Lot Size Acres: 0.1033

Rental Info

  • Pets Allowed: Yes

Multi Family

  • Lot Size Area: 4500.0000 Square Feet
  • Manager Approval: Yes

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 4, 2025
Sold by
Chateau Gv Llc and Miyamoto Investment Company
Bought by
Caidh Mor Real Estate Investments Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$18,743,000
Outstanding Balance
$18,661,717
Interest Rate
6.77%
Mortgage Type
New Conventional
Estimated Equity
-$18,516,717

Purchase Details

Closed on
Apr 26, 2023
Sold by
Sherleen R Miyamoto Trust and Kathleen S Miyamoto Trust
Bought by
Miyamoto Investment Company

Purchase Details

Closed on
Mar 17, 2023
Sold by
Jow Family Trust
Bought by
Sycamore Seven Eight Llc

Purchase Details

Closed on
Jan 11, 2023
Sold by
Yamashiro Tateshi
Bought by
Yamashiro Joann M

Purchase Details

Closed on
Sep 23, 2022
Sold by
Jow William M
Bought by
Jow Family Trust

Purchase Details

Closed on
May 5, 2022
Sold by
Kajikawa Carole N
Bought by
Chateau Gv Llc

Purchase Details

Closed on
May 3, 2022
Sold by
Kajikawa Trust
Bought by
Kajikawa Carole N and Yamashiro Joann M

Purchase Details

Closed on
Sep 18, 2018
Sold by
Jow William M and Jow Elaine T
Bought by
Jow William M and Jow Elaine T

Purchase Details

Closed on
Feb 5, 2015
Sold by
Miyamoto Kathleen Sachie
Bought by
Miyamoto Kathleen S

Purchase Details

Closed on
Feb 2, 2015
Sold by
Miyamoto Sherleen Reiko
Bought by
Mlyamoto Sherleen R

Purchase Details

Closed on
Jan 20, 2015
Sold by
Miyamoto Wesley Shizuo
Bought by
Miyamoto Wesley S

Purchase Details

Closed on
Jan 13, 2014
Sold by
Kajikawa Tadashi
Bought by
Kajikawa Tadashi

Purchase Details

Closed on
Jun 17, 2013
Sold by
Kajikawa Tadashi
Bought by
Kajikawa Tadashi

Purchase Details

Closed on
Apr 9, 2013
Sold by
Kajikawa Tadashi
Bought by
Kajikawa Tadashi

Purchase Details

Closed on
Mar 28, 2002
Sold by
Jow Cheryl C and Jow William J
Bought by
Jow William M

Purchase Details

Closed on
Sep 18, 1998
Sold by
Jow Rose R
Bought by
Jow William M
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Grant Deed $35,310,000 Fidelity National Title Compan
Quit Claim Deed -- First American Title
Grant Deed -- First American Title
Quit Claim Deed -- Accommodation/Courtesy Recordi
Quit Claim Deed -- --
Quit Claim Deed -- --
Quit Claim Deed -- --
Grant Deed -- Law Office Of John S Torii
Deed -- Law Office Of John S Torii
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Quit Claim Deed -- None Available
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- --
Gift Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $18,743,000 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
02/25/2026 02/25/26 Sold $307,500 -3.1% $203 / Sq Ft
02/09/2026 02/09/26 Pending -- -- --
11/18/2025 11/18/25 Price Changed $317,500 -2.2% $210 / Sq Ft
10/21/2025 10/21/25 Price Changed $324,500 -4.4% $215 / Sq Ft
10/03/2025 10/03/25 For Sale $339,500 -- $225 / Sq Ft
Source: California Regional Multiple Listing Service (CRMLS)

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: California Regional Multiple Listing Service (CRMLS)

MLS Number: NDP2509628

California Regional Multiple Listing Service (CRMLS)

APN: 217-122-70

Your Personal Tour Guide

Ask me questions while you tour the home.