meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='373208' 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, 1709171740
ffd_listing_title, 438 Campbell Avenue, San Francisco, CA, 94134
ffd_mls_id, 423923828
ffd_salesforce_id, a0EUd000000khI5MAI
num_of_fireplaces__c, 0
num_of_rooms__c, 9
of_units__c, 2
address2__c, 438 Campbell Avenue, San Francisco, CA, 94134
pba__address_pb__c, 438 Campbell Avenue, San Francisco, CA, 94134
agent_only_remarks__c, Supra lockbox to show anytime. Disclosure package & offer instructions = [email protected] Entire building for sale as another option, see MLS#423924692. Other TIC MLS #423923582 (440 Campbell) must be sold simultaneously with this unit at COE.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary;Victorian;Traditional
bath_features__c, Tub w/Shower Over;Tile;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1908
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Chris Chour
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-01-08T19:47:06.000+0000
days_on_market__c, 51
dom__c, 17
ffd_description_pb, Views and more views from this gorgeous prime upper level TIC unit. Imagine living in a space where you can walk out directly to the gorgeous manicured backyard with multiple terraces and views that will take your breath away. Live sumptuously with period detail styling and an updated kitchen perfect to cater to the standards of an epicurean. The floorplan is generous with 3 bedrooms, 1 bathroom, and in-unit washer & dryer closet. Ideal for an easy commute to downtown or the Peninsula/South Bay. Enjoy nearby McLaren Park and the weather that this location has to offer.
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
pba__floortype_pb__c, Other;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2024-02-29T01:47:13.000+0000
pba__latitude_pb__c, 37.714955
pba__latitude_property__c, 37.714955
laundry_features__c, Laundry Closet;Hookups Only
listed_date__c, 2024-01-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Heffernan
listing_agent_mls_id__c, 805965
ffd_listingagentname, Tim Heffernan
listing_agent_number__c, 166016071
listing_co_agent_mls_id__c, 816646
listing_co_agent_number__c, 1075602
listing_co_office_mls_id__c, RACM
listing_co_office_name__c, RealEstateAdvisor.com
listing_co_office_number__c, 29083
listing_office_mls_id__c, RACM
listing_office_name__c, RealEstateAdvisor.com
listing_office_number__c, 29083
pba__listingprice_pb__c, 549000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.404593
mls_id__c, 423923828
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-01-08
original_price__c, 549000
overall_days_on_market__c, -81821
pba__pendingdate__c, 2024-01-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-02-28T09:27:36.000+0000
price_per_square_foot__c, 212.81
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd000000khI5MAI
room_type__c, Bonus Room;Laundry;Kitchen
sale_date__c, 2024-02-26
sale_price__c, 515000
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, 2420
size__c, 2420
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Campbell
subdist__c, Visitacion Valley
ffd_name, 438 Campbell Avenue, San Francisco, CA, 94134
view__c, Panoramic;Bay;Water;Hills;Mountains;Other;Valley;Ridge
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530716517-1.jpg