meta_query='key:subdist__c;value:Westwood Highlands|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='339253' 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, 815 Joost Avenue, San Francisco, CA, 94127
ffd_mls_id, 423900216
ffd_salesforce_id, a0E8W00000cpeskUAA
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 815 Joost Avenue, San Francisco, CA, 94127
pba__address_pb__c, 815 Joost Avenue, San Francisco, CA, 94127
agent_only_remarks__c, As-Is Trust SAle. Broker's Note: Please note that any 3rd party property inspections provided are for informational purposes only and buyers and agents should not rely on them for making offer or purchase decisions. Buyers are advised to get any all all inspections they deem necessary. Buyers should also verify all square footage and any and all room counts, room legality and permit history for themselves.
appliances__c, Free Standing Gas Oven;Free Standing Gas Range
architectural_style__c, Art Deco
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1925
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-08-26T02:52:08.000+0000
days_on_market__c, 34
dom__c, 14
ffd_description_pb, This charming Westwood Highlands 2BD/1.5BA Barrel Front, with big bonus spaces and a large 4,477 Sq Ft double-lot, is ready for its next owners' vision & passion! 815 Joost, which is chock-full of 1920s period charm, greets visitors with an inviting formal living room with vaulted ceilings & a fireplace with lovely surrounds & built-ins, a bright formal dining room, a roomy kitchen with adjoining breakfast room, two spacious bedrooms with views to the South, & a full bath with shower over tub, all on one level. Warm hardwood floors, vintage period details & good light run throughout. Downstairs are two well-sized bonus rooms, one with a wet bar, a large unfinished basement area, a bonus bath & garage parking, all with good ceiling height ready for possible further living space expansion within the home's current envelope (buyers to verify). A big back yard ready for gardening, entertainment & play (and perhaps other expansion options) complete this rare opportunity in a sought-after neighborhood. Excellent central location close to local schools, parks, Ocean Ave, West Portal, Monterey Blvd. & Stonestown shopping & dining & easy public transit & freeway access to Downtown, the Peninsula & Silicon Valley. Bring your tape measure & creativity & come see the opportunity on Joost!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-09-27T10:48:21.000+0000
pba__latitude_pb__c, 37.73211
pba__latitude_property__c, 37.73211
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2023-08-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, de Vries
listing_agent_mls_id__c, 803319
ffd_listingagentname, Andrew de Vries
listing_agent_number__c, 803319
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, 949000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=hBvZuhuJ2fi&brand=0&mls=1&
pba__longitude_pb__c, -122.45383
lower_level__c, Garage,Partial Bath(s)
mls_id__c, 423900216
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-08-24
original_price__c, 949000
overall_days_on_market__c, -81684
parking_access__c, Independent
parking_features__c, Attached,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2023-09-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-09-26T20:29:43.000+0000
price_per_square_foot__c, 1141.73
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cpeskUAA
roof__c, Bitumen;Composition
room_type__c, Storage;Office;Living Room;Dining Room;Media Room;Primary Bedroom
sale_date__c, 2023-09-26
sale_price__c, 1450000
selling_agent_mls_id__c, 807207
selling_agent_number__c, 1003190
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, BarbCo
pba__status__c, Closed
pba__totalarea_pb__c, 1270
size__c, 1270
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Joost
subdist__c, Westwood Highlands
ffd_name, 815 Joost Avenue, San Francisco, CA, 94127
view__c, City;Hills;Valley
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530660818-1.jpg