meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='378938' 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-04-11 08:39:15
[post_modified_gmt] => 2024-04-11 15:39:15
[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, 1719485719
ffd_listing_title, 20 Appleton Avenue, San Francisco, CA, 94110
ffd_mls_id, 424005308
ffd_salesforce_id, a0EUd000002BqNBMA0
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 20 Appleton Avenue, San Francisco, CA, 94110
pba__address_pb__c, 20 Appleton Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Please set 28 day close to coordinate with refinance of upper unit. Brand new condo conversion with Sirkin's office! Disclosures available here: https://app.disclosures.io/link/20-Appleton-Avenue-wffffz6h. Contractor bid available upon request for: (1) walling off pocket door between bedroom 1 and bedroom 2 ($5150), (2) removing wall between living room and kitchen ($15k). Sellers loved the flexible floor plan, but I know buyers ask these questions so we pre-solved them in case someone wants to take the home in a different direction! Buyer to verify square footage; measurements range from 3000 for the building per tax record (seller approximates 1410 for unit 20 and 1590 for unit 22); prior appraisal measured 1331/1484, drawings in .IO; buyer to measure to their satisfaction.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-06-01T10:48:42.000+0000
days_on_market__c, 63
dom__c, 53
ffd_description_pb, Transparent Pricing! Welcome to this stunning 2-bed, 2-bath condo nestled in the heart of Bernal Heights, complete with solar that offsets all PG&E! Upon entering, you are greeted by flowing hardwood floors. To the right is a bedroom with decorative fireplace with north-facing views toward San Francisco. The second bedroom is en-suite with a large modern bath and a small workspace with beautiful natural light. The modern kitchen is a chef's delight, featuring sleek countertops, stainless steel appliances, and ample cabinet space. The living area is bathed in natural light filtered through mature trees at the rear of the home, which creates a warm and welcoming ambiance for relaxation and entertainment. This condo also boasts a private balcony, providing a serene outdoor space to enjoy your morning coffee or unwind after a long day, as well as a second full remodeled bath in the hallway, two large hall storage closets, designated garage storage, and a shared yard. The shared yard deserves a special note, as it includes multiple seating areas, a hot tub, a BBQ, and a fire pit with custom stamped concrete patio at the rear. Located in desirable Bernal Heights, this home is less than a ten minute walk to Cortland and an easy 3 minute drive to the 280 - welcome home!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Sewer,Trash,Water
pba__hoafees__c, 350
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2024-06-27T10:47:33.000+0000
pba__latitude_pb__c, 37.73842
pba__latitude_property__c, 37.73842
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2024-01-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gabrielle
pba__listing_agent_lastname__c, Bunker
listing_agent_mls_id__c, 810512
ffd_listingagentname, Gabrielle F Bunker
listing_agent_number__c, 1046582
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1300000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=2jn61vfpBzn&brand=0&mls=1&
pba__longitude_pb__c, -122.42323
mls_id__c, 424005308
master_property__c, a0OUd000005n95iMAA
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-25
original_price__c, 1300000
overall_days_on_market__c, -81929
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-06-26T14:47:19.000+0000
price_per_square_foot__c, 976.71
pba__propertytype__c, Condominium
ListingId, a0EUd000002BqNBMA0
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1331
size__c, 1331
spa__c, 1
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Appleton
subdist__c, Bernal Heights
ffd_name, 20 Appleton Avenue, San Francisco, CA, 94110
view__c, City
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530725039-1.jpg