meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215347' 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
(
)
)
ffd_listing_title, 56 Macedonia Street, San Francisco, CA, 94110
ffd_mls_id, 507777
ffd_salesforce_id, a0E1I00000TRnytUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 56 Macedonia Street, San Francisco, CA, 94110
pba__address_pb__c, 56 Macedonia Street, San Francisco, CA, 94110
agent_only_remarks__c, For showings: https://calendly.com/williamtransf/56-macedonia. After scheduling, please send PEAD form to [email protected], [email protected]. PEAD form must be provided prior to appointment. Please follow all showing guidelines. To request disclosure via GLIDE [Copy/Paste]: https://app.glide.com/share/1yBtuYNs3SZb121egqzGDc/ For more information, contact William at 650-759-5157 or Mike at 415-990-1195.
appliances__c, Dishwasher;Insulated Water Heater;Disposal;Refrigerator;Hood Over Range;Tankless Water Heater;ENERGY STAR Qualified Appliances;Cooktop Stove;Built-In Oven
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Shower Stall(s);Tub;Low-Flow Toilet(s);Dual Flush Toilet
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1959
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mike Duong
pba__contingentdate__c, 2020-11-13
ffd_createddate, 2020-10-07T21:46:08.000+0000
days_on_market__c, 1015
dom__c, 54
ffd_description_pb, A modern masterpiece set on the north slope of Bernal Heights, this sprawling 4 bedroom, 3.5 bath oasis boasting stunning skyline and Bay water views. Featuring an open-concept living/dining areas, a stunning fireplace, and a gourmet kitchen featuring top of the line finishes, a generously sized island, custom cabinetry, a suite of stainless steel Thermador appliances, and panoramic doors that open up to the back patio overlooking a heavenly backyard. the exterior features three separate decks, including a breathtaking roof deck with dramatic 360-degree panoramic views encompassing the San Francisco skyline and Bay. For added convenience, the home is also equipped with a side-by-side two-car garage and laundry room. This home enjoys the splendor of short commutes into downtown, panoramic hilltop views, and unparalleled proximity to world-class dining, entertainment, parks, cafes and so much more.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Electric
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2022-01-25T15:36:51.000+0000
pba__latitude_pb__c, 37.745714
pba__latitude_property__c, 37.745714
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-10-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, William
pba__listing_agent_lastname__c, Tran
listing_agent_mls_id__c, 804647
ffd_listingagentname, William T Tran
listing_agent_number__c, 166014288
listing_co_agent_mls_id__c, 812384
listing_co_agent_number__c, 1056340
listing_co_office_mls_id__c, SEQUOIA
listing_co_office_name__c, Sequoia Real Estate
listing_co_office_number__c, 28359
listing_office_mls_id__c, SEQUOIA
listing_office_name__c, Sequoia Real Estate
listing_office_number__c, 28359
pba__listingprice_pb__c, 2599000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.406803
pba__lotsize_pb__c, 0.09
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Master Bedroom,Partial Bath(s)
mls_id__c, 507777
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-10-07
original_price__c, 2599000
overall_days_on_market__c, 147
parking__c, Attached,Garage
parking_features__c, Attached,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-11-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000TRnytUAD
roof__c, Bitumen
sale_date__c, 2020-12-02
sale_price__c, 2600000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 806586
selling_agent_name__c, Kristen Stuecher
selling_agent_number__c, 166017247
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Macedonia
subdist__c, Bernal Heights
ffd_name, 56 Macedonia Street, San Francisco, CA, 94110
view__c, Panoramic;City Lights;Bay;Water;Downtown;San Francisco
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Weather Stripped
pba__yearbuilt_pb__c, 1959
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371806-1.jpg
ListingId, a0E1I00000TRnytUAD