meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210225' 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-03-19 14:18:08
[post_modified_gmt] => 2024-03-19 21:18:08
[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, 144 Murray Street, San Francisco, CA, 94112
ffd_mls_id, 495382
ffd_salesforce_id, a0E1I00000RtxvrUAB
num_of_fireplaces__c, 2
num_of_rooms__c, 5
of_units__c, 0
address2__c, 144 Murray Street, San Francisco, CA, 94112
pba__address_pb__c, 144 Murray Street, San Francisco, CA, 94112
agent_only_remarks__c, Offers to be reviewedon 03/11/20 Wed@ 12:00pm. Sellers reserve the right to accept, counter and/or refuse any or all offers. Thank you installed show anytime, please leave lights on, disclosure package link-https://app.disclosures.io/link/144-Murray-Street-jwg33v4m. Email or text LA for any questions.BUYERS AND/OR BUYER'S AGENT MUST USE DUE DILIGENCE TO VERIFY PERMIT, BUILDING SQUARE FOOTAGE & LOT SIZE WITH CITY AUTHORITIES AND PROFESSIONAL SURVEYOR(S) BEFORE WRITING AN OFFER.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Self/Cont Clean Oven
architectural_style__c, Contemporary;Traditional
bath_features__c, Shower Stall(s);Tub;Remodeled;Tile;Low-Flow Toilet(s);Dual Flush Toilet
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1925
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-03-03T11:46:07.000+0000
days_on_market__c, 1233
dom__c, 8
ffd_description_pb, Get ready to be charmed as this stunning rebuilt Bernal Heights home has it all; 4+ bdrms, 4 baths, a fantastic floorplan, great light+fully detached, walkout decks, a large yard + a very desirable location This incredible Traditional home built in 1925 & remodeled throughout in 2019/2020. The clean lines combined w/ natural light through the many large view windows exemplifies the scale and open feel. 4 spacious beds + 1 office/den, 2 with its own full-sized baths. The main level showcases an open plan kitchen/living room/large dining area with sleek lighting, glass paned stairways and beautiful hardwood floors plus 1 master bedroom with over size bathroom, another bedroom and full hall bathroom. The gourmet kitchen features a large center island, new Thermador appliances with beautiful custom-made Belmont cabinets. A modern glass staircase leads to the lower floor with 2 beds (1master bedm)+office/den and a family room equipped with wet bar, fireplace and sliding doors leads to yard.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Electric;Family Room
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Electric;Gas
interior_features__c, Wet Bar
ffd_lastmodifieddate, 2022-01-12T15:28:28.000+0000
pba__latitude_pb__c, 37.73332
pba__latitude_property__c, 37.73332
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-02-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Yao Hong
pba__listing_agent_lastname__c, Yang
listing_agent_mls_id__c, 810727
ffd_listingagentname, Yao Hong Yang
listing_agent_number__c, 1047637
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REEB
listing_office_name__c, Real Estate eBroker
listing_office_number__c, 196509135
pba__listingprice_pb__c, 1999000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/395446478
pba__longitude_pb__c, -122.424214
pba__lotsize_pb__c, 0.08
lower_level__c, Bedroom(s),Living Room
mls_id__c, 495382
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Dining Room;Family Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-03-03
original_price__c, 1999000
overall_days_on_market__c, 89
parking__c, Detached,Deck,Garage
parking_access__c, Tandem
parking_features__c, Deck,Detached,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-03-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1024.39
pba__propertytype__c, Single Family Residence
id, a0E1I00000RtxvrUAB
roof__c, Bitumen
sale_date__c, 2020-04-06
sale_price__c, 2310000
selling_agent_mls_id__c, 807162
selling_agent_name__c, Laura Lanzone
selling_agent_number__c, 166018324
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, North Point Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 2255
size__c, 2255
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Murray
subdist__c, Bernal Heights
ffd_name, 144 Murray Street, San Francisco, CA, 94112
transportation__c, 1 Block,2 Blocks
website_property_type__c, Single Family Home
window_features__c, Window Screens
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/360720-1.jpg
ListingId, a0E1I00000RtxvrUAB