meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237679' 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] => 2023-10-31 09:10:48
[post_modified_gmt] => 2023-10-31 16:10:48
[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, 251 Teddy Avenue, San Francisco, CA, 94134
ffd_mls_id, 422681039
ffd_salesforce_id, a0E8W00000XlNklUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 251 Teddy Avenue, San Francisco, CA, 94134
pba__address_pb__c, 251 Teddy Avenue, San Francisco, CA, 94134
agent_only_remarks__c, Offer review as it is received. SUPRA Lockbox located by the front gate. Please follow COVID protocol and wear masks and sanitize your hands when showing the property As-is Trustee sales and no death on the property. The disclosures and inspection reports are available at https://app.disclosures.io/link/251-Teddy-Avenue-z66l13i0. The buyers are advised to perform due diligence prior to writing an offer. Pre-escrow with Chicago Title - Michael Yip.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator;Plumbed For Ice Maker
architectural_style__c, Contemporary;Art Deco
bath_features__c, Tub w/Shower Over;Tile;Low-Flow Toilet(s);Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2022-07-23T00:47:36.000+0000
days_on_market__c, 362
dom__c, 11
ffd_description_pb, Extensively renovated in 2018, this 1941 contemporary home located at Teddy Ave. is your perfect starter home. The main level showcased an open living/dining and kitchen area. The kitchen features quartz countertop, SS high end appliances, and dark oak shaker cabinetry. Two spacious bedrooms facing the garden, and a full bath. Entering the lower level features a retreat/office, full bathroom, and a bedroom. Addt'l features include oak hardwood flooring throughout the house, shutter blinds, 200AMP electrical service, entertainment system, landscaped garden with composite decking, stackable W/D in the garage and additional parking at the driveway. Ideally situated near highway 101, public transit, and Visitacion shopping corridor.
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Laundry
entry_level__c, 0
exterior_features__c, Entry Gate
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
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T17:23:47.000+0000
pba__latitude_pb__c, 37.7147164
pba__latitude_property__c, 37.7147164
laundry_features__c, Inside Room;Washer/Dryer Stacked Included;Inside Area;Stacked Only
listed_date__c, 2022-07-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Brandon
pba__listing_agent_lastname__c, Chen
listing_agent_mls_id__c, 807882
ffd_listingagentname, Brandon S Chen
listing_agent_number__c, 1028110
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 1050000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=dAFVW4KWjuV
pba__longitude_pb__c, -122.4076523
mls_id__c, 422681039
main_level__c, Full Bath(s);Bedroom(s);Garage;Street Entrance;Retreat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-07-22
original_price__c, 1050000
overall_days_on_market__c, -81286
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-08-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 839.75
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000XlNklUAF
roof__c, Shingle
room_type__c, Office;Laundry;Kitchen;Living Room;Primary Bedroom 2+
sale_date__c, 2022-08-24
sale_price__c, 1200000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector;Video System
selling_agent_mls_id__c, 292638
selling_agent_number__c, 292638
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1429
size__c, 1429
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Teddy
subdist__c, Visitacion Valley
ffd_name, 251 Teddy Avenue, San Francisco, CA, 94134
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Coverings;Window Screens;Weather Stripped;Caulked/Sealed
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530501372-1.jpg