meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='386202' 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, 1726656838
ffd_listing_title, 86 Tucker Avenue, San Francisco, CA, 94134
ffd_mls_id, 424064726
ffd_salesforce_id, a0EUd00000368IwMAI
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 86 Tucker Avenue, San Francisco, CA, 94134
pba__address_pb__c, 86 Tucker Avenue, San Francisco, CA, 94134
agent_only_remarks__c, Any questions, please text Jeremie Young 415-828-3162 and Deniz Kahramaner 650-770-3100. More at 86Tucker.com . Pre-sale escrow has been opened with Old Republic Title, Susan Hanna. Tax records state 1,025 sqft. Floor plan artist measured 1,470 sqft of total livable square footage including the lower bonus space. Buyers are advised to verify square footage and the permit history and/or legality of any rooms and or bathrooms if they deem it necessary. Agents and sellers make no warranties. Seller is open to buyer concessions. Disclosures: https://app.disclosures.io/link/86-Tucker-Avenue-ighlsrxz OFFERS: Please submit offers, if any, on Thursday Sept 19, by 12 PM. Please let us know if you have any questions.
appliances__c, Microwave;Hood Over Range;Built-In Gas Range;Free Standing Refrigerator;Gas Plumbed
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1946
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Deniz Kahramaner
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-09-12T21:47:29.000+0000
days_on_market__c, 6
dom__c, 6
ffd_description_pb, Lovingly cared for and maintained since 2005, 86 Tucker Ave offers approximately 1,470 sqft of thoughtfully designed living space and captivating views of the San Bruno Mountains. This charming home features 3 bedrooms, 2.5 bathrooms, and a bright, airy living area with rich cherry oak hardwood floors. The upper level includes a well-appointed kitchen with skylights, creating a light-filled space ideal for cooking and entertaining. The lower level features a versatile in-law suite with 1 bedroom, 1 bathroom, and a kitchenette, perfect for guests or rental income. The property also includes a 1-car garage with additional storage and laundry facilities, plus 2 extra parking spaces in front. Enjoy a beautifully manicured backyard with a pergola, ideal for outdoor gatherings. Conveniently located near 101/280 freeways, the Bayshore Caltrain Station, MUNI transit, and McLaren Park, this residence offers effortless access to all that the area has to offer. Welcome to a blend of comfort, care, and convenience at 86 Tucker Ave, where your new home awaits!
district__c, SF District 10
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
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, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-09-18T10:47:26.000+0000
pba__latitude_pb__c, 37.7159907
pba__latitude_property__c, 37.7159907
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2024-08-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jeremie
pba__listing_agent_lastname__c, Young
listing_agent_mls_id__c, 816681
ffd_listingagentname, Jeremie Young
listing_agent_number__c, 1075633
listing_co_agent_mls_id__c, 813335
listing_co_agent_number__c, 1060923
listing_co_office_mls_id__c, ATLSA
listing_co_office_name__c, ATLASA
listing_co_office_number__c, 29111
listing_office_mls_id__c, ATLSA
listing_office_name__c, ATLASA
listing_office_number__c, 29111
pba__listingprice_pb__c, 886000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=WcmHFVQvydv
pba__longitude_pb__c, -122.4053947
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Kitchen,Street Entrance
mls_id__c, 424064726
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Skylight/Solar Tube
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2024-09-12
open_house_end__c, 2024-09-18T20:00:00.000+0000
open_house_start__c, 2024-09-18T18:00:00.000+0000
original_price__c, 886000
overall_days_on_market__c, -82069
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Interior Access,Uncovered Parking Spaces 2+
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 602.72
pba__propertytype__c, Single Family Residence
ListingId, a0EUd00000368IwMAI
roof__c, Tar/Gravel
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate;Window Security Bars
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1470
size__c, 1470
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Tucker
subdist__c, Visitacion Valley
ffd_name, 86 Tucker Avenue, San Francisco, CA, 94134
view__c, City;City Lights;Mountains;Valley
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Screens;Weather Stripped
pba__yearbuilt_pb__c, 1946
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530841036-1.jpg
