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] => 2021-12-01 19:45:45
[post_modified_gmt] => 2021-12-02 03:45:45
[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
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E8W00000WiZbbUAF
pba__address_pb__c 625 Campbell Avenue, San Francisco, CA, 94134
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 3
pba__bedrooms_pb__c 4
days_on_market__c 35
mls_id__c 422654682
pba__totalarea_pb__c 2840
pba__latitude_pb__c 37.7158203
pba__longitude_pb__c -122.4090003
pba__state_pb__c CA
pba__status__c Active
pba__street_pb__c Campbell
listed_date__c 2022-04-18
sale_date__c 1800-01-01
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 1468000
pba__listingtype__c Sale
sale_price__c 0
address2__c 625 Campbell Avenue, San Francisco, CA, 94134
pba__listing_agent_firstname__c Juanjuan
pba__listing_agent_lastname__c Huang
view__c Bay;Water;Hills;Mountains;Valley
pba__halfbathrooms_pb__c 0
parkingspaces__c 4
pba__postalcode_pb__c 94134
year_build_text__c 1985
size__c 2840
subdist__c Visitacion Valley
listing_agent_mls_id__c 808889
listing_co_office_number__c 0
listing_office_number__c 27342
listing_office_name__c Compass
listing_office_mls_id__c COMP3
of_units__c 0
district__c SF District 10
selling_agent_number__c 0
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c -81208
dom__c 23
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 516.9
parking_type__c On Site (Single Family Only)
original_price__c 1468000
agent_only_remarks__c BOM, no fault of seller. Offers reviewed as they come in. Absolutely a gorgeous modern view home with plenty of living and storage space. The total square footage of 2,840 SF, per graphic artist, includes the rec room (used to a legal basement storage room) on the backyard level. Buyer is encouraged to conduct their own investigation to verify the square footage. Disclosure link: https://app.disclosures.io/link/625-Campbell-Avenue-27s0ia6z
Modern luxe living by McLaren Park. Nestled in a quiet cul-de-sac street & steps to the 2nd largest park of the City, this semi-detached 1985 home was beautifully & tastefully remodeled & thoughtfully designed with smart & modern finishes that creates a unique metropolitan oasis of peace & tranquility. The inviting foyer leads up to a grand living room with a modern gas fireplace, gorgeous views of the Bay, hills & valleys, adjacent to a well-appointed kitchen with deluxe finishes & appliances, extends into a formal dining area. 3 large bedrooms & 2 luxury baths on the main level. The street level offers a guest bedroom, a full bath & a spacious family room with wet bar leads out to an attached deck with views of the Bay, perfect for entertaining or a guest/teen/in-law quarter. A large bonus room on the garden level is ideal for an office/playroom/gym with direct access to an easy-care serene flat backyard garden. 2-car side-by-side garage with parkings in the deep driveway.
