meta_query='key:subdist__c;value:Westwood Highlands|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216058' 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, 355 Valdez Avenue, San Francisco, CA, 94127
ffd_mls_id, 509631
ffd_salesforce_id, a0E1I00000TjM3OUAV
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 355 Valdez Avenue, San Francisco, CA, 94127
pba__address_pb__c, 355 Valdez Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Offers due Tuesday 11/24 by 2:00 PM. Please use SFAR Purchase Contract only. Stipulate on Purchase Contract that Buyer's initial deposit to be in escrow within one business day of acceptance (by Wednesday 11/25). Escrow opened with First American Title, Liz Paglinawan 415-682-1112. 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 beforeviewing home. All visitors must wear masks & use hand sanitizer. 3D Tour available on the MLS, just click on visual media. To see floor plans, go to www.AndrewHerrera.com, click on View Listing and then Property Brochure.
appliances__c, Dishwasher;Gas Range;Refrigerator;Hood Over Range
architectural_style__c, Traditional;Spanish/Med
bath_features__c, Tub w/Shower Over;Remodeled;Tile;Granite
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1926
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-11-18T22:46:17.000+0000
days_on_market__c, 973
dom__c, 6
ffd_description_pb, Terrific Spanish Mediterranean view home tucked away on great block! Inviting garden entrance w/cobblestone walkway leads to notable front door & into foyer w/coat closet. Magnificent formal living rm w/open arched doorway & dramatic barrel ceiling boasts a grand fireplace w/Batchelder tile surround & gumwood mantel, built-in bookshelves w/glass-paneled doors, hardwood floors, huge bay window w/five floor to ceiling arched windows & stunning views to the Bay, hills and trees! Gorgeous banquet-size formal dining rm w/exotic wood paneling & impressive built-in china hutch! Tastefully remodeled kit showcases all stainless-steel appliances incl a Wolf gas range, Bosch dishwasher & LG refrigerator, granite counters w/tile backsplash, custom cabinets & light-filled breakfast rm. Master suite w/big walk-in closet & private bath overlooks the garden. Giant family rm w/access to the yard, wine/hobby rm & laundry closet. Fabulous landscaped backyard w/enormous patio, built-in BBQ, lawn & garden!
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;Gas Piped
pba__floortype_pb__c, Wood
hoa_dues__c, 25
pba__hoafees__c, 25
pba__hoafrequency_pb__c, Annually
hoa_name__c, Westwood Highlands
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2022-01-25T15:40:15.000+0000
pba__latitude_pb__c, 37.733213
pba__latitude_property__c, 37.733213
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-11-18
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, 1895000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.andrewherrera.com/
pba__longitude_pb__c, -122.457019
pba__lotsize_pb__c, 0.08
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 509631
main_level__c, Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-11-18
original_price__c, 1895000
overall_days_on_market__c, 181
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener,Interior Access,Side-by-Side,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-11-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 995.81
pba__propertytype__c, Single Family Residence
id, a0E1I00000TjM3OUAV
room_type__c, Wine Cellar
sale_date__c, 2020-12-24
sale_price__c, 2612000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 804303
selling_agent_name__c, Dan Dodd
selling_agent_number__c, 166013815
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2623
size__c, 2623
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Valdez
subdist__c, Westwood Highlands
ffd_name, 355 Valdez Avenue, San Francisco, CA, 94127
view__c, City Lights;Partial;Bay;Water;Hills;Mountains
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/373944-1.jpg
ListingId, a0E1I00000TjM3OUAV