meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='372239' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70688
[post_author] => 4
[post_date] => 2018-11-30 20:41:51
[post_date_gmt] => 2018-11-30 20:41:51
[post_content] => Found on the far south side of San Francisco, Visitacion Valley slopes steeply down. From the heights of the valley in its northeast corner, ramble down to bay level where San Francisco ends and Daly City begins. Homes in the northeast heights offer some soaring southern views.
[post_title] => Visitacion Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => visitacion-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-01 10:43:28
[post_modified_gmt] => 2024-11-01 17:43:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70688
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1707782136
ffd_listing_title, 120 Desmond Street, San Francisco, CA, 94134
ffd_mls_id, 423922804
ffd_salesforce_id, a0EUd000000flNyMAI
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 120 Desmond Street, San Francisco, CA, 94134
pba__address_pb__c, 120 Desmond Street, San Francisco, CA, 94134
agent_only_remarks__c, Trust sale. Some family is currently living here so please make an appointment. Pets on property as well. Text 650-271-2308 for showings. At least 2 hours notice please. Combo lockbox code given with business card via text and confirmed appt. Pre-opened escrow preferred at Fidelity National Title-Jose Flores (Burlingame). May need a 29 day rent back. Offers due on Tuesday 1/9 4pm to BE UPLOADED ON DISCLOSURES I/O-Use SF RPA, reapproval, POFs and disclosures IO coversheet.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1932
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-01-10
ffd_createddate, 2024-01-02T11:47:46.000+0000
days_on_market__c, 41
dom__c, 9
ffd_description_pb, Explore the untapped potential of 120 Desmond in Visitacion Valley, San Franciscoa fixer-upper with a sprawling canvas and a hidden treasure: a remarkably large backyard. This expansive outdoor space presents an opportunity to create your private oasis within the city. Imagine lush gardens, entertaining areas, or a tranquil retreat, all set against the backdrop of scenic views. With this generous outdoor haven, 120 Desmond offers not only a chance to reimagine the interiors but also to design and cultivate a captivating backyard sanctuary. Unleash your creativity and transform this property into a unique home, where both indoor and outdoor spaces seamlessly blend in perfect harmony. There is also a hidden gem: an unpermitted in-law unit boasting one bedroom and one bath.
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Linoleum;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-02-12T23:47:13.000+0000
pba__latitude_pb__c, 37.710384
pba__latitude_property__c, 37.710384
laundry_features__c, In Garage
listed_date__c, 2024-01-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Helen
pba__listing_agent_lastname__c, Yong
listing_agent_mls_id__c, 981607
ffd_listingagentname, Helen Yong
listing_agent_number__c, 981607
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, EXPRE
listing_office_name__c, eXp Realty of California, Inc
listing_office_number__c, 26334
pba__listingprice_pb__c, 799000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.405689
lower_level__c, Bedroom(s),Full Bath(s),Garage,Living Room
mls_id__c, 423922804
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-01-02
original_price__c, 799000
overall_days_on_market__c, -81815
parking_access__c, Tandem
parking_features__c, Attached,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-01-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-02-12T08:10:27.000+0000
price_per_square_foot__c, 759.26
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000000flNyMAI
roof__c, Tile
sale_date__c, 2024-02-09
sale_price__c, 1025000
selling_agent_mls_id__c, 810526
selling_agent_number__c, 1046686
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, CENTURY 21 Real Estate Alliance
pba__status__c, Closed
pba__totalarea_pb__c, 1350
size__c, 1350
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Desmond
subdist__c, Visitacion Valley
ffd_name, 120 Desmond Street, San Francisco, CA, 94134
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1932
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530715218-1.jpg