meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='332044' 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
(
)
)
ffd_listing_title, 248 Ordway Street, San Francisco, CA, 94134
ffd_mls_id, 423739626
ffd_salesforce_id, a0E8W00000bcJb6UAE
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 248 Ordway Street, San Francisco, CA, 94134
pba__address_pb__c, 248 Ordway Street, San Francisco, CA, 94134
agent_only_remarks__c, Call James (530) 318-3101 before showing. Property is a fixer, DO NOT OPEN Back Sliding Glass Door. Stairs to backyard are beneath floor of lower bedroom, flashlight provided. No Stove/Refrigerator
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1952
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Paul Robertson
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-05-05T17:48:07.000+0000
days_on_market__c, 606
dom__c, 3
ffd_description_pb, The views are set, the house needs loving. After 45 years of being called home, it's ready for an update and new owners. Contractors, Builders and the most adventurous buyers have the opportunity to maximize this hilltop home. It comes with an amazing view from Sutro Tower all the way through downtown San francisco and to the east bay. A nice deck off the kitchen or back room would make this home an entertainers paradise. It even has a flat backyard! Bring your inspiration and ideas to this fixer. Come check out the 180 Degree views.
district__c, SF District 10
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2023-07-13T18:51:49.000+0000
pba__latitude_pb__c, 37.719886
pba__latitude_property__c, 37.719886
laundry_features__c, None
listed_date__c, 2023-05-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, James
pba__listing_agent_lastname__c, Cullen
listing_agent_mls_id__c, 811500
ffd_listingagentname, James P Cullen
listing_agent_number__c, 1051785
listing_co_agent_mls_id__c, 814216
listing_co_agent_number__c, 1065029
listing_co_office_mls_id__c, KWADVSF
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28861
listing_office_mls_id__c, KWADVSF
listing_office_name__c, KW Advisors
listing_office_number__c, 28861
pba__listingprice_pb__c, 778000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.403462
lower_level__c, Bedroom(s),Garage
mls_id__c, 423739626
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-05-05
original_price__c, 778000
overall_days_on_market__c, -81573
parking_access__c, Tandem
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-05-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 930.62
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bcJb6UAE
room_type__c, Storage;Bonus Room;Living Room;Dining Room;Workshop;Primary Bathroom
sale_date__c, 2023-05-17
sale_price__c, 778000
selling_agent_mls_id__c, 811500
selling_agent_number__c, 1051785
selling_co_agent_mls_id__c, 814216
selling_co_agent_number__c, 1065029
selling_co_office_mls_id__c, KWADVSF
selling_co_office_name__c, KW Advisors
selling_co_office_number__c, 28861
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 836
size__c, 836
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Ordway
subdist__c, Visitacion Valley
ffd_name, 248 Ordway Street, San Francisco, CA, 94134
view__c, City;Panoramic;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Sutro Tower
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1952
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530614093-1.jpg
_yoast_indexnow_last_ping, 1735679245