meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='423495' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15717
[post_author] => 4
[post_date] => 2018-11-02 19:54:32
[post_date_gmt] => 2018-11-02 19:54:32
[post_content] => Once a San Francisco skunkworks flying pirate flags filled with humble Victorian cottages owned by ladies who loved ladies and looked forward to long dog walks. Then it gentrified. Silicon Valley stock options splurged on homes here. Dwell magazine arrived next to document the results. While it might be one Bernal, the neighborhood has several distinct geographic vibes and styles. It's not complicated, perhaps recently algorithmically optimized?
[post_title] => Bernal Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bernal-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-11 10:53:21
[post_modified_gmt] => 2024-11-11 18:53:21
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15717
[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, 1737778805
ffd_listing_title, 507 Andover Street, San Francisco, CA, 94110
ffd_mls_id, 424068631
ffd_salesforce_id, a0EUd0000048D2jMAE
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
pba__address_pb__c, 507 Andover Street, San Francisco, CA, 94110
address2__c, 507 Andover Street, San Francisco, CA, 94110
agent_only_remarks__c, Showings by appointment only - home is currently tenant-occupied. Please do not disturb occupants at any time. Property to be sold in as-is condition with subject to tenants-rights. Prefer to use Katerina Rosignuolo WFG Title 689 Portola Dr,SF 415-753-3003 Esc #24-185231. Disclosures.IO Link: https://app.disclosures.io/link/507-Andover-Street-f3d072lq
appliances__c, Dishwasher;Insulated Water Heater;Disposal;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian;A-Frame
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mia Baldini
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-01-24T20:47:08.000+0000
days_on_market__c, 121
dom__c, 40
ffd_description_pb, Amazingly remodeled and customized gem of a home in highly sought after Bernal Heights neighborhood. Entire home has been re-invented for a modern lifestyle with quality upgrades and finishes. Must see to appreciate. Main level offers an open floor-plan with a den, dining area and updated working kitchen, designed for a cook and offering high-end appliances. Main floor also offers a half bath with laundry room. Top floor is dedicated to the primary suite. Large windows flood this area with natural light. Grand-sized walk-in closet and private en-suite bath. Lower level offers a second family den, a full bath, and an additional bedroom. High ceilings and easy access to the back yard area. Close proximity to Cortland Ave. Do not miss out on this gem of a property!
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
electric__c, 220 Volts
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2025-01-25T03:47:01.000+0000
pba__latitude_pb__c, 37.73698
pba__latitude_property__c, 37.73698
laundry_features__c, Inside Room;Cabinets
listed_date__c, 2024-09-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Manuel
pba__listing_agent_lastname__c, Cobo
listing_agent_mls_id__c, 802852
ffd_listingagentname, Manuel Cobo
listing_agent_number__c, 802852
listing_co_agent_mls_id__c, 816236
listing_co_agent_number__c, 1075204
listing_co_office_mls_id__c, C-BA
listing_co_office_name__c, Century 21 Baldini Realty
listing_co_office_number__c, 770
listing_office_mls_id__c, C-BA
listing_office_name__c, Century 21 Baldini Realty
listing_office_number__c, 770
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.41641
mls_id__c, 424068631
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-09-25
original_price__c, 1395000
overall_days_on_market__c, -82082
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-12-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 2025-01-24T11:58:31.000+0000
price_per_square_foot__c, 729.17
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000048D2jMAE
road_surface_type__c, Asphalt
roof__c, Composition
room_type__c, Laundry;Kitchen;Living Room;Dining Room
sale_date__c, 2025-01-22
sale_price__c, 1400000
security_features__c, Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 803339
selling_agent_number__c, 166012442
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1920
size__c, 1920
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Andover
subdist__c, Bernal Heights
ffd_name, 507 Andover Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530847702-1.jpg