meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214810' 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-04-11 11:09:58
[post_modified_gmt] => 2024-04-11 18:09:58
[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, 39 Tucker Avenue, San Francisco, CA, 94134
ffd_mls_id, 504957
ffd_salesforce_id, a0E1I00000THjxGUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 39 Tucker Avenue, San Francisco, CA, 94134
pba__address_pb__c, 39 Tucker Avenue, San Francisco, CA, 94134
agent_only_remarks__c, Website www.39TuckerRetreat.com to view Matterport and site plans. Please follow CAR Covid19 protocols/safety guidelines while visiting. Neither seller nor broker warrants square footage measurements. Tax records show 1,200 sq ft. Draftsperson measured 1,362 sq ft. 3R shows permitted rooms added. Driveway can accommodate a small vehicle. Investigate all to buyer's satisfaction.
appliances__c, Dishwasher;Gas Water Heater;Gas Range;Microwave;Disposal;Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Remodeled;Tile;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1948
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mike Tekulsky
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-17T00:51:17.000+0000
days_on_market__c, 1036
dom__c, 9
ffd_description_pb, Beautiful serene view home cleverly sheltered w/ tree alcove & planters, this is where you'll embrace your new life! Pano south-facing views fr all levels stretch fr bay's water to the San Bruno Mts and westward. Fabulous 3BR 2BA abode offers lovely 1940s character w/ corner FP in LR. Bright KIT w/ skylight, dining area, stylish cabinetry & lighting, new LVT flooring, new DW, verdant outlooks. Gorgeously refinished maple floors on both levels. True IN-OUT living on custom decks of beautiful Ipe hardwood w/ clear glass railing to optimize the sweeping vistas. Imagine everyday grilling & dining w/ the enormous view backdrop. Primary bedroom suite w/ full bath, ample storage + private Media Rm/Den offers rest & relaxation. 2 sliding glass doors capture plenty of light. Restorative outdoor soaking tub & spa shower amidst potted bamboo on 1st level of splendid landscaped yard w/ terraces for the urban gardener. Garage/storage/driveway/WD. Easy commute location, blks to McLaren Park
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Slate;Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:34:46.000+0000
pba__latitude_pb__c, 37.7152504
pba__latitude_property__c, 37.7152504
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-07-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ron
pba__listing_agent_lastname__c, Wong
listing_agent_mls_id__c, 806373
ffd_listingagentname, Ron Wong
listing_agent_number__c, 164505277
listing_co_agent_mls_id__c, 806372
listing_co_agent_number__c, 164505236
listing_co_office_mls_id__c, COMP41
listing_co_office_name__c, Compass
listing_co_office_number__c, 27887
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 998000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=xFcpvV3xrEk
pba__longitude_pb__c, -122.4043416
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s),Master Bedroom
mls_id__c, 504957
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-16
original_price__c, 998000
overall_days_on_market__c, 75
parking__c, Attached,Garage,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-09-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 770.93
pba__propertytype__c, Single Family Residence
id, a0E1I00000THjxGUAT
room_type__c, Den
sale_date__c, 2020-10-16
sale_price__c, 1050000
selling_agent_mls_id__c, 805632
selling_agent_name__c, Dylan Hunter
selling_agent_number__c, 166015628
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1362
size__c, 1362
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Tucker
subdist__c, Visitacion Valley
ffd_name, 39 Tucker Avenue, San Francisco, CA, 94134
transportation__c, 2 Blocks
view__c, Panoramic;City Lights;Garden/Greenbelt;Bay;Water;Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Window Screens
pba__yearbuilt_pb__c, 1948
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370410-1.jpg
ListingId, a0E1I00000THjxGUAT