meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='346260' 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-08-27 13:13:08
[post_modified_gmt] => 2024-08-27 20:13:08
[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, 1701346445
ffd_listing_title, 3733 San Bruno Avenue, San Francisco, CA, 94134
ffd_mls_id, 423917266
ffd_salesforce_id, a0E8W00000dUf2KUAS
num_of_fireplaces__c, 0
num_of_rooms__c, 10
of_units__c, 0
address2__c, 3733 San Bruno Avenue, San Francisco, CA, 94134
pba__address_pb__c, 3733 San Bruno Avenue, San Francisco, CA, 94134
agent_only_remarks__c, Upstairs 2 levels are vacant. Sellers will carry 1st loan with 25% or more down payment, interest rate appx. 6% for at least 5 years. Sellers reserve rights to accept, counter or reject any offers. Buyer or Buyer's agent needs to verify sqft and permits information. Pre-sale escrow has been opened with Old Republic Title Company, Maria Smith. Please call or text Wendy Chen 415-699-9500 for more information and showing appt.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, A-Frame
bath_features__c, Tub w/Shower Over;Marble;Tile;Window
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 6
year_build_text__c, 2003
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-18T02:48:37.000+0000
days_on_market__c, 44
dom__c, 38
ffd_description_pb, Very Unique 4 stories huge house in most desirable location. 5084 SQFT. Built in 2003, not under San Francisco rent control ordinance. Remodeled Kitchens and bathrooms. Wooden floor through out. 2 furnaces in the building. Good for big family, investment or Airbnb. Walking distance to shops, transportation. Easy access to Highway 101,280.
district__c, SF District 10
entry_level__c, 0
exterior_features__c, Balcony;Fireplace
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas;Natural Gas
ffd_lastmodifieddate, 2023-11-30T11:47:42.000+0000
pba__latitude_pb__c, 37.7147904
pba__latitude_property__c, 37.7147904
laundry_features__c, In Garage;Washer Included
listed_date__c, 2023-10-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Wendy
pba__listing_agent_lastname__c, Chen
listing_agent_mls_id__c, 401719
ffd_listingagentname, Wendy W Chen
listing_agent_number__c, 401719
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, FIRN
listing_office_name__c, First National Realty
listing_office_number__c, 1071
pba__listingprice_pb__c, 1480000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3996426
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 423917266
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tile;Jetted Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-10-17
original_price__c, 1480000
overall_days_on_market__c, -81738
parking_access__c, Side by Side
parking_features__c, Attached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-11-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-11-29T16:10:32.000+0000
price_per_square_foot__c, 300.94
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dUf2KUAS
room_type__c, Kitchen;In Law Apartment;Living Room
sale_date__c, 2023-11-29
sale_price__c, 1530000
selling_agent_mls_id__c, 401719
selling_agent_number__c, 401719
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, First National Realty
pba__status__c, Closed
pba__totalarea_pb__c, 5084
size__c, 5084
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, San Bruno
subdist__c, Visitacion Valley
ffd_name, 3733 San Bruno Avenue, San Francisco, CA, 94134
view__c, City Lights;Bay;San Francisco
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 2003
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530693725-1.jpg
