meta_query='key:subdist__c;value:Westwood Highlands|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='230478' 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, 348 Hazelwood Avenue, San Francisco, CA, 94127
ffd_mls_id, 489842
ffd_salesforce_id, a0E1I00000H11SJUAZ
address2__c, 348 Hazelwood Avenue, San Francisco, CA, 94127
pba__address_pb__c, 348 Hazelwood Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Easy to show by appointment. Link to unbranded 3D Tour w/Floor Plan and specs/measurements: https://youriguide.com/348_hazelwood_ave_san_francisco_ca?unbranded Escrow opened with Old Republic Title, David Banker. Disclosures available in Disclosure.io
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1926
pba__city_pb__c, San Francisco
ffd_createddate, 2019-09-12T21:46:33.000+0000
days_on_market__c, 1406
dom__c, 47
ffd_description_pb, Can you say Trick-or-Treat? Beautiful Westwood Highlands home! Fully detached, and Meticulously maintained! Built in 1926, with beautiful hardwood floors throughout. Grand formal living room with barrel ceiling and wood burning fireplace. Formal dining room with built-in buffet ~ perfect for serving holiday meals. The kitchen has a separate sunny breakfast room. The upper level offers 3 bright spacious bedrooms and plenty of storage. The secluded patio area is great for relaxing. The garage has parking for two cars plus multiple storage areas, and potential expansion opportunities. This beautiful home is close to West Portal for great dining and shopping Easy access to 280, Muni, Bart and downtown San Francisco.
district__c, SF District 4
external_listing__c, 1
hoa_dues__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-03-01T20:07:48.000+0000
pba__latitude_pb__c, 37.7336087
pba__latitude_property__c, 37.7336087
listed_date__c, 2019-07-29
pba__listing_agent_firstname__c, Reid
pba__listing_agent_lastname__c, Rankin
listing_agent_mls_id__c, 803594
listing_agent_number__c, 803594
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP39
listing_office_name__c, Compass
listing_office_number__c, 27886
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__listing_website__c, https://youriguide.com/348_hazelwood_ave_san_francisco_ca?unbranded
pba__longitude_pb__c, -122.4557691
pba__lotsize_pb__c, 0.08
mls_id__c, 489842
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2019-09-12
original_price__c, 1695000
overall_days_on_market__c, 1406
parking__c, Attached,Garage,Auto Door,Interior Access
parking_type__c, On Site
price_per_square_foot__c, 722.35
pba__propertytype__c, Single-Family Home
id, a0E1I00000H11SJUAZ
sale_date__c, 2019-11-08
sale_price__c, 1600000
selling_agent_mls_id__c, 404543
selling_agent_name__c, Thomas Cooke
selling_agent_number__c, 404543
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, 2215
size__c, 2215
pba__state_pb__c, CA
pba__street_pb__c, Hazelwood
subdist__c, Westwood Highlands
ffd_name, 348 Hazelwood Avenue, San Francisco, CA, 94127
website_property_type__c, Single Family Home
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/355669-1.jpg
ListingId, a0E1I00000H11SJUAZ