meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217702' 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, 667 Campbell Avenue, San Francisco, CA, 94134
ffd_mls_id, 421528726
ffd_salesforce_id, a0E1I00000TwyC1UAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 667 Campbell Avenue, San Francisco, CA, 94134
pba__address_pb__c, 667 Campbell Avenue, San Francisco, CA, 94134
agent_only_remarks__c, Following COVID-19 Protocol; Virtual tour at http://www.667CampbellAve.com Schedule showing through Showing Time and send PEAD_V prior to showing. Call agent for CBS Code. Disclosures available on Disclosures.io. Accepting offers on March 31st by Noon at [email protected] or by Disclosures.io. Submit offers on SFAR Purchase Agreement w/proof of funds/pre-approval letter, and Disclosure Packet Coversheet. Pre-escrow open with North American Title Company / Escrow #56606-20-02651
appliances__c, Dishwasher;Gas Water Heater;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1952
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Carolyn R Cannon-Sequiera
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-03-20T21:26:48.000+0000
days_on_market__c, 856
dom__c, 16
ffd_description_pb, Welcome to 667 Campbell Ave located in San Francisco's sunny Visitation Valley. This charming home filled with lots of natural light features 3 spacious bedrooms with views of San Bruno Mountain, 1 full bath, living room with fireplace, and an eat-in-kitchen with all new appliances. Freshly painted interior and refinished hardwood flooring throughout. Downstairs has a bonus room with a half-bath and one car garage parking. Large backyard with many fruit trees. Walking distance to John McLaren Park, Coffman Pool, San Bruno Avenue shopping and restaurants and public transportation. Close to 101/280 and Caltrain Station.
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Carpet;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
ffd_lastmodifieddate, 2022-01-25T15:47:16.000+0000
pba__latitude_pb__c, 37.7160611
pba__latitude_property__c, 37.7160611
laundry_features__c, In Garage;Washer Included;Dryer Included;Sink
listed_date__c, 2021-03-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Timothy
pba__listing_agent_lastname__c, Cannon
listing_agent_mls_id__c, 144192
ffd_listingagentname, Timothy J Cannon
listing_agent_number__c, 144192
listing_co_agent_mls_id__c, 804127
listing_co_agent_number__c, 166013585
listing_co_office_mls_id__c, SFRE
listing_co_office_name__c, SanFranRealEstate.Com
listing_co_office_number__c, 1969
listing_office_mls_id__c, SFRE
listing_office_name__c, SanFranRealEstate.Com
listing_office_number__c, 1969
pba__listingprice_pb__c, 885000
pba__listingtype__c, Sale
pba__listing_website__c, https://667CampbellAve.com/mls
pba__longitude_pb__c, -122.4098125
lower_level__c, Garage,Partial Bath(s)
mls_id__c, 421528726
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-03-15
original_price__c, 885000
overall_days_on_market__c, 116
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Private,Workshop in Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-03-31
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 977.56
pba__propertytype__c, Single Family Residence
id, a0E1I00000TwyC1UAJ
roof__c, Flat
room_type__c, Bonus Room;Kitchen;Living Room
sale_date__c, 2021-05-03
sale_price__c, 1220000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, 811500
selling_agent_number__c, 1051785
selling_co_agent_mls_id__c, 814216
selling_co_agent_number__c, 1065029
selling_co_office_mls_id__c, KWRSF
selling_co_office_name__c, Keller Williams San Francisco
selling_co_office_number__c, 26158
selling_office_name__c, Keller Williams San Francisco
pba__status__c, Closed
pba__totalarea_pb__c, 1248
size__c, 1248
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Campbell
subdist__c, Visitacion Valley
ffd_name, 667 Campbell Avenue, San Francisco, CA, 94134
view__c, San Francisco;Mountains
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1952
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530200596-1.jpg
ListingId, a0E1I00000TwyC1UAJ