Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 201 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 201 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 201 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

11740 Manchester Way
Porter Ranch, CA 91326
SUJUAN DAI with RE/MAX 2000 REALTY, original listing - (626) 956-0188

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,498,000
Beds: 5
Baths: Full: 6
Status: Active
SqFt: 4800 Square Feet
Agency: RE/MAX 2000 REALTY
Agency Phone: (626) 956-0188

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: This spacious and bright house is located in Wycliffe, the most luxurious gated community in Portland, a 24-hour guard-gated neighborhood. This stunning mansion was meticulously built in 2020 by renowned builder Toll Brothers, perfectly blending modern luxury with secluded privacy. The open floor plan and seamless indoor-outdoor living spaces make this home ideal for entertaining. The beautiful open kitchen is equipped with top-of-the-line stainless steel appliances, stylish cabinetry, a walk-in pantry, a butler's pantry, a large central island, and a breakfast bar overlooking the spacious living room. The outdoor area includes a covered California room, a waterfall, and a BBQ area. The formal dining room, living room, one guest bedroom, one bathroom, one office space, and a three-car garage are all located on the first floor. The second floor features brand-new flooring, a large master bathroom with a beautiful bathtub, and all secondary bedrooms with en-suite bathrooms and spacious closets. In total, there are four bedrooms and four bathrooms on the second floor. The homeowner has fully paid off the solar panels, making this the perfect place to enjoy an unparalleled lifestyle. The property is located in an excellent school district, close to the highly sought-after Sierra Canyon School and the award-winning K-8 Portland Community School. The community offers convenient living and transportation, with proximity to The Vineyard shopping center, which features top-notch shopping, dining, and entertainment, including cinemas. Nearby, you'll find fully equipped medical facilities and other amenities. *** Please check the listing agent's details for excluded items. All information is deemed reliable but cannot be guaranteed. Buyers are advised to verify independently.
MlsNumber: --
ListingId: WS24197359


Listing Provided By: RE/MAX 2000 REALTY, original listing
Phone: (626) 662-5800
Office Phone: (626) 956-0188
Agent Name: SUJUAN DAI
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App