meta_query='key:subdist__c;value:Westwood Highlands|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215662' 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-04-11 08:17:47
[post_modified_gmt] => 2024-04-11 15:17:47
[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, 62 Cresta Vista Drive, San Francisco, CA, 94127
ffd_mls_id, 508558
ffd_salesforce_id, a0E1I00000TTPaoUAH
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 62 Cresta Vista Drive, San Francisco, CA, 94127
pba__address_pb__c, 62 Cresta Vista Drive, San Francisco, CA, 94127
agent_only_remarks__c, Offers due Thursday 10/29 by 12 noon. Use SFAR Purchase Contract only. Stipulate on Purchase Contract that Buyer's initial deposit to be in escrow within one business day of acceptance. Escrow opened with North American Title, Katerina Rosignuolo 415-919-9853. Do NOT Send Text Messages. Email ONLY for ALL showing requests, we are not using ShowingTime and will not respond to any automated messages. Property is being marketed under Covid19 guidelines. Buyer's agent must provide their buyer's signed PEAD-V and pre-approval letter or POF before viewing home. All visitors must wear masks & use hand sanitizer. 3D Tour available on the MLS, just click on visual media. Floor plans are on property brochure in the last two photos. Escrow opened with North American Title, Katerina Rosignuolo 415-919-9853.
appliances__c, Dishwasher;Gas Range;Refrigerator;Hood Over Range;Double Oven
architectural_style__c, Contemporary;Craftsman
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1960
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-10-22T16:45:15.000+0000
days_on_market__c, 1000
dom__c, 7
ffd_description_pb, Terrific Mid-Century Modern Contemporary view home tucked away on huge lot! Inviting garden entrance leads to gated entry & into a lobby-like foyer. Magnificent formal living rm boasts corner fireplace w/natural stone surround, picture window, hardwood floors, sliding glass door that opens to a covered patio & expansive walk-out deck w/sweeping views from the Bay to the Pacific Ocean. Light-filled formal dining rm! Beautifully remodeled gourmet kitchen w/skylight & stunning southerly views showcases an enormous work-island, lunch counter, all stainless-steel appliances incl Viking gas range top w/hood & Thermador built-in double oven, wine fridge, double sink, honed Caesarstone counters, custom wood cabinets & comfortable breakfast rm that opens to walk-out patio. Grand master suite w/big walk-in closet & fabulous period tile bath. Huge family rm w/wet-bar, walk-out deck & hot-tub, large workroom, sep laundry rm. Meticulous, park-like landscaped backyard w/patio, lawn & lush plantings!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning;Stone
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa_name__c, Westwood Highlands
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2022-01-25T15:38:20.000+0000
pba__latitude_pb__c, 37.7352384
pba__latitude_property__c, 37.7352384
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-10-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, Herrera II
listing_agent_mls_id__c, 404547
ffd_listingagentname, Andrew Herrera II
listing_agent_number__c, 404547
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHFP
listing_office_name__c, Berkshire Hathaway-Franciscan
listing_office_number__c, 1665
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.andrewherrera.com/
pba__longitude_pb__c, -122.458184
pba__lotsize_pb__c, 0.15
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Partial Bath(s)
mls_id__c, 508558
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-10-22
original_price__c, 1995000
overall_days_on_market__c, 182
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s);Covered Patio
pba__pendingdate__c, 2020-10-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 741.88
pba__propertytype__c, Single Family Residence
id, a0E1I00000TTPaoUAH
room_type__c, Storage;Laundry
sale_date__c, 2020-11-13
sale_price__c, 2529800
security_features__c, Smoke Detector;Security Gate
selling_agent_mls_id__c, 811419
selling_agent_name__c, Bradley W. Joe
selling_agent_number__c, 1051536
selling_co_agent_mls_id__c, 810063
selling_co_agent_name__c, Alexander F. Lurie
selling_co_agent_number__c, 1044526
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 3410
size__c, 3410
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Cresta Vista
subdist__c, Westwood Highlands
ffd_name, 62 Cresta Vista Drive, San Francisco, CA, 94127
transportation__c, 3 Blocks
view__c, Ocean;Panoramic;City Lights;Partial;Bay;Water;Hills;Mountains
website_property_type__c, Single Family Home
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1960
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/372634-1.jpg
ListingId, a0E1I00000TTPaoUAH