meta_query='key:subdist__c;value:Westwood Highlands|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217620' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70668
[post_author] => 4
[post_date] => 2018-11-30 20:30:43
[post_date_gmt] => 2018-11-30 20:30:43
[post_content] => Stately single-family homes with views to the southwest at the base of Mt. Davidson define this West of Twin Peaks classic. Like its adjacent neighbors, it assumes you've got a car to get you to and from some jaw-dropping views.
[post_title] => Westwood Highlands
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => westwood-highlands
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 11:34:43
[post_modified_gmt] => 2024-11-21 19:34:43
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70668
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 129 Cresta Vista Drive, San Francisco, CA, 94127
ffd_mls_id, 421526940
ffd_salesforce_id, a0E1I00000TwgNbUAJ
num_of_fireplaces__c, 2
num_of_rooms__c, 9
of_units__c, 0
address2__c, 129 Cresta Vista Drive, San Francisco, CA, 94127
pba__address_pb__c, 129 Cresta Vista Drive, San Francisco, CA, 94127
agent_only_remarks__c, Shows like a model home and very easy to tour - agents must book appointment using calendly link: https://calendly.com/morgan-cook-realtor/129-cresta-vista Submit your signed PEAD at least 2 hours before tour to receive CBS code (Supra box is on front door). Leave lights on and remove shoes or wear disposable booties which are located at front door (please discard in trash bag after use). For disclosures: https://app.disclosures.io/link/129-Cresta-Vista-Drive-p2h4gnfo Offers due March 17 by 5pm. Please use SFAR contract and email offers to [email protected], including proof of funds, preapproval letter, & signed disclosure coversheet. Visit www.129CrestaVista.com for more details including aerial video, 3D tour, & home video tour
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Wine Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Quartz
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1988
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-03-16T01:01:53.000+0000
days_on_market__c, 1392
dom__c, 7
ffd_description_pb, Located in the coveted neighborhood of Westwood Highlands, this gorgeous contemporary home has been completely remodeled (with permits, over $300k spent!) from top to bottom including all new exterior siding! Main level features a spacious family room w/tall ceilings and oversized windows that flood the home with natural light and includes an inviting floor plan that flows into the chef's kitchen showcasing a large island w/gorgeous quartz countertops and waterfall edge, soft-close cabinets, Viking appliances, and wine fridge. Upper level is highlighted by a huge main suite w/soak-in tub, walk-in closet, fireplace, and stunning views. Entry level 2nd ensuite & oversized 2 car side-by-side garage complete this perfect home. Conveniently located near award winning public/private schools, West Portal's shops & restaurants, Trader Joes, Whole Foods & easy access to Glen Park BART, 101 & 280!
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Electric;Family Room;Master Bedroom
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:46:54.000+0000
pba__latitude_pb__c, 37.7356655
pba__latitude_property__c, 37.7356655
laundry_features__c, Inside Area;Ground Floor;Washer Included;Dryer Included;Cabinets
listed_date__c, 2021-03-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Morgan
pba__listing_agent_lastname__c, Cook
listing_agent_mls_id__c, 808184
ffd_listingagentname, Morgan R Cook
listing_agent_number__c, 1039152
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP46
listing_office_name__c, Compass
listing_office_number__c, 28120
pba__listingprice_pb__c, 1988000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=https://my.matterport.com/show/?m=orH4pP8q7Df
pba__longitude_pb__c, -122.4568673
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 421526940
main_level__c, Kitchen;Dining Room;Family Room
master_bathroom_features__c, Quartz;Soaking Tub;Radiant Heat;Multiple Shower Heads
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-03-10
original_price__c, 1988000
overall_days_on_market__c, 184
parking_access__c, Side by Side
parking_features__c, Attached,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-03-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1046.25
pba__propertytype__c, Single Family Residence
id, a0E1I00000TwgNbUAJ
roof__c, Tar/Gravel
sale_date__c, 2021-04-08
sale_price__c, 2511000
security_features__c, Video System;Security System Owned
selling_agent_mls_id__c, MLSL5073214
selling_agent_number__c, 981224703
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Intero Real Estate Services
pba__status__c, Closed
pba__totalarea_pb__c, 2400
size__c, 2400
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Cresta Vista
subdist__c, Westwood Highlands
ffd_name, 129 Cresta Vista Drive, San Francisco, CA, 94127
view__c, Ocean;Panoramic;San Francisco
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1988
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530196984-1.jpg
ListingId, a0E1I00000TwgNbUAJ
_yoast_indexnow_last_ping, 1735665700