meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217340' 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
(
)
)
ffd_listing_title, 637 Andover Street, San Francisco, CA, 94110
ffd_mls_id, 421522927
ffd_salesforce_id, a0E1I00000Tw6DVUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 637 Andover Street, San Francisco, CA, 94110
pba__address_pb__c, 637 Andover Street, San Francisco, CA, 94110
agent_only_remarks__c, Vacant and easy to show. Please use Calendly link: https://calendly.com/greggoryonzotasher/637-andover-st Disclosures up shortly on Disclosures.io Extensive, permitted remodel including large addition of square footage below to create primary suite (previously unfinished, unpermitted space). Tax records show 1679sqft due to previously unpermitted addition that was brought up to code in most recent permitted remodel. Remodel plans that reflect accurate square footage in disclosure package.
appliances__c, Dishwasher;Insulated Water Heater;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Ice Maker;Built-In Refrigerator;Gas Cook Top;Gas Plumbed
architectural_style__c, Craftsman
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-02-25T20:12:54.000+0000
days_on_market__c, 1405
dom__c, 3
ffd_description_pb, Extensively remodeled and spacious 1920's craftsman finally reaching it's full, glorious potential! Permitted added square footage that includes a huge new living and dining space which is flooded with natural light from windows on three sides offering stunning views of the rolling hills and Bay to the east. The kitchen is also filled with natural light from several windows and a skylight to illuminate the high-end appliances including Gaggenau convection oven. The polished concrete countertops and island offer the unique charm that the neighborhood of Bernal itself has come to be known for along with custom glass art backsplash. Downstairs, a large new primary suite complete with 15+' ceilings and en suite, spa-like bath which opens to a lush and serene garden. Two more bedrooms upstairs give this home the space for a family with plenty of space to work from home. All just steps from the trendy & charming shops and cafes of Cortland Ave!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
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, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:45:48.000+0000
pba__latitude_pb__c, 37.735551
pba__latitude_property__c, 37.735551
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-02-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gregory
pba__listing_agent_lastname__c, Onzo-Tasher
listing_agent_mls_id__c, 808339
ffd_listingagentname, Gregory R Onzo-Tasher
listing_agent_number__c, 1033683
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG06
listing_office_name__c, Vanguard Properties
listing_office_number__c, 25987
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=gkvVs6yguzK
pba__longitude_pb__c, -122.41654
lower_level__c, Master Bedroom
mls_id__c, 421522927
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Low-Flow Toilet(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-02-25
original_price__c, 1795000
overall_days_on_market__c, 159
parking_access__c, Tandem
parking_features__c, Attached,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-02-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1136.36
pba__propertytype__c, Single Family Residence
id, a0E1I00000Tw6DVUAZ
roof__c, Tar/Gravel
room_type__c, Storage;Laundry;Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom;Great Room
sale_date__c, 2021-03-25
sale_price__c, 2175000
selling_agent_mls_id__c, 804125
selling_agent_number__c, 166013580
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1914
size__c, 1914
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Andover
subdist__c, Bernal Heights
ffd_name, 637 Andover Street, San Francisco, CA, 94110
view__c, City;Panoramic;Bay;Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530188970-1.jpg
ListingId, a0E1I00000Tw6DVUAZ
_yoast_indexnow_last_ping, 1735665086