meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='328276' 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] => 2018-11-30 20:41:51
[post_modified_gmt] => 2018-11-30 20:41:51
[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, 127 Teddy Avenue, San Francisco, CA, 94134
ffd_mls_id, 423718382
ffd_salesforce_id, a0E8W00000a8P9XUAU
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 127 Teddy Avenue, San Francisco, CA, 94134
pba__address_pb__c, 127 Teddy Avenue, San Francisco, CA, 94134
agent_only_remarks__c, Supra lockbox is on the front gate. Key opens door next to the garage. Please make sure all lights are turned off and doors locked after showing. Call Joseph at 415-980-9262 with questions and offer instructions.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1951
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Roque E Fernandes
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-03T20:46:56.000+0000
days_on_market__c, 47
dom__c, 10
ffd_description_pb, Brilliantly renovated gem in vibrant and sunny Visitacion Valley. This bright and contemporary home offers a flexible floorplan with four bedrooms and three bathrooms on two levels. The upper level features a light-filled living area with a fireplace, an elegant kitchen and dining area, three bedrooms and two full bathrooms including a lovely primary suite. The lower level has an additional bedroom and full bath plus a spacious family room that opens to an inviting rear yard with mature fruit trees and a charming patio. This prime location is just steps away from the Visitacion Valley Greenway Children's Play Garden and the unique shops and restaurants on Leland Avenue. Conveniently close to McLaren Park, Caltrain, San Bruno Avenue, Lightrail and Highway 101.
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-03-22T10:48:05.000+0000
pba__latitude_pb__c, 37.713887
pba__latitude_property__c, 37.713887
listed_date__c, 2023-01-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joseph
pba__listing_agent_lastname__c, Chav
listing_agent_mls_id__c, 805827
ffd_listingagentname, Joseph Chav
listing_agent_number__c, 166015886
listing_co_agent_mls_id__c, 355981
listing_co_agent_number__c, 355981
listing_co_office_mls_id__c, COLD03
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 875
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 1050000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=PE2MFGjvHnw&brand=0
pba__longitude_pb__c, -122.405151
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 423718382
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-02-03
original_price__c, 1050000
overall_days_on_market__c, -81482
parking_access__c, Tandem
parking_features__c, Attached,Enclosed,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2023-02-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-03-21T15:19:55.000+0000
price_per_square_foot__c, 681.82
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a8P9XUAU
sale_date__c, 2023-03-20
sale_price__c, 1200000
security_features__c, Security Gate
selling_agent_mls_id__c, 813803
selling_agent_number__c, 1063040
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, 1760
size__c, 1760
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Teddy
subdist__c, Visitacion Valley
ffd_name, 127 Teddy Avenue, San Francisco, CA, 94134
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1951
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530576043-1.jpg