meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='322206' 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, 801 Moultrie Street, San Francisco, CA, 94110
ffd_mls_id, 422710089
ffd_salesforce_id, a0E8W00000a4QO3UAM
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 801 Moultrie Street, San Francisco, CA, 94110
pba__address_pb__c, 801 Moultrie Street, San Francisco, CA, 94110
agent_only_remarks__c, Go directly to show any time between 7 a.m. and 8 p.m. Your clients will love this gorgeous home! Full disclosure package here: https://app.disclosures.io/link/801-Moultrie-Street-n51fo2cy
appliances__c, Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Built-In Refrigerator
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1948
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Polina De-Levi
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-11-29T01:46:50.000+0000
days_on_market__c, 233
dom__c, 16
ffd_description_pb, Spectacular corner home, completely reimagined and renovated throughout! Beautiful views of the bay and city create a pleasant and harmonious vibe. Modern, open-concept layout features an airy, elegant space for entertaining, dining, cooking or hanging out with family. Gourmet kitchen boasts a suite of Thermador appliances and a huge center island. Wide-plank hardwood floors, recessed lighting, and an electric fireplace perfectly complement the modern style. Radiant heat under the floors provides the perfect temperature. Spacious primary bedroom suite is on the main level. Primary bath has dual sinks, oval bathtub, and a separate shower stall. Lower level enters the media-entertainment room, perfect for relaxing, watching TV or a home office. This level has two more large bedrooms and 2 full baths, plus access to a nice-sized, low-maintenance backyard. Amazing home in a superb location. Best weather in the city, close to great restaurants, shops, parks and quick freeway access.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Electric
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-07-13T18:09:30.000+0000
pba__latitude_pb__c, 37.7347355
pba__latitude_property__c, 37.7347355
laundry_features__c, Hookups Only;In Basement
listed_date__c, 2022-11-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Leon
pba__listing_agent_lastname__c, De-Levi
listing_agent_mls_id__c, 317053
ffd_listingagentname, Leon De-Levi
listing_agent_number__c, 317053
listing_co_agent_mls_id__c, 239904
listing_co_agent_number__c, 239904
listing_co_office_mls_id__c, RADIUS
listing_co_office_name__c, Radius Agent Realty
listing_co_office_number__c, 28554
listing_office_mls_id__c, RADIUS
listing_office_name__c, Radius Agent Realty
listing_office_number__c, 28554
pba__listingprice_pb__c, 1799000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=SKmEU7ZPx6o
pba__longitude_pb__c, -122.4160368
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 422710089
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Living Room;Dining Room
master_bathroom_features__c, Double Sinks;Soaking Tub;Radiant Heat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-11-28
original_price__c, 1799000
overall_days_on_market__c, -81415
parking_access__c, Independent
parking_features__c, Attached,Covered,Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-12-14
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 919.51
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a4QO3UAM
room_type__c, Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c, 2023-01-04
sale_price__c, 1805000
selling_agent_mls_id__c, 806718
selling_agent_number__c, 166017501
selling_co_agent_mls_id__c, 813032
selling_co_agent_number__c, 1059036
selling_co_office_mls_id__c, BRAVA
selling_co_office_name__c, Brava Real Estate
selling_co_office_number__c, 28638
selling_office_name__c, Brava Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1963
size__c, 1963
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Moultrie
subdist__c, Bernal Heights
ffd_name, 801 Moultrie Street, San Francisco, CA, 94110
view__c, City;Bay
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1948
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530557908-1.jpg