meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218259' 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, 190 Emmett Court, San Francisco, CA, 94110
ffd_mls_id, 421517266
ffd_salesforce_id, a0E1I00000TymWXUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 190 Emmett Court, San Francisco, CA, 94110
pba__address_pb__c, 190 Emmett Court, San Francisco, CA, 94110
agent_only_remarks__c, Agents: Offers due Wednesday April 21 @ 12 noon. Showing: Please park on Precita and walk up! There are two free-standing buildings on one lot. The entire patio garden and hot tub (pictured) are exclusive to this unit. Tax records show original SQ FT as 1,209, this BLDG was a two-unit, graphic artist measures 1,110 SQ FT, Tax records as condo shows 800 SQ FT main level only. One car parking in private garage, one car parking off street in front of garage. This home will make you smile! Virtual Tour: https://californiacasbah.com Call Wendy with any questions. No installed laundry in bldg but plenty of space in garage for install.
appliances__c, Microwave;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range
architectural_style__c, Victorian;Cottage;Bungalow;Farmhouse;Cabin
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2021-04-22T20:55:22.000+0000
days_on_market__c, 826
dom__c, 7
ffd_description_pb, Fully detached, on an idyllic Precita cul-de-sac, a pristine residence w/ a fresh, California modernity, embraced by dreamy outdoor space, crowned inventive Casbah exoticism, a sublime attic, a travelers retreat at home. The airy open plan, glorious natural light, wood flooring & an enviable indoor-outdoor flow are key factors of livability. Open plan, pristine KIT, serene primary bed,& fresh bath, whose gorgeous tile evokes a tropical lagoon. Epic outdoor space surrounded w/lush plantings, gas FP, spectacular sunny deck & 7-person hot tub. Travel from breezy California to sky-lit attic rooms: city views, jewel-like lighting, silk clad, invite creativity: visionary, playful, richly inspired. Offices, social hang-out, maker studio, this space is a testament to the power of home as self-expression. Amenities: solar power, air conditioning, 2 car pkg & seismic updates, & the neighborly atmosphere of a private court. Technically a condo, it enjoys the privacy of a freestanding home.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts,Photovoltaics Seller Owned,See Remarks
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 100
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:49:40.000+0000
pba__latitude_pb__c, 37.747056
pba__latitude_property__c, 37.747056
laundry_features__c, See Remarks;None
listed_date__c, 2021-04-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Wendy
pba__listing_agent_lastname__c, Storch
listing_agent_mls_id__c, 803139
ffd_listingagentname, Wendy M Storch
listing_agent_number__c, 803139
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1150000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=FgyTLhX8uJR
pba__longitude_pb__c, -122.416265
lower_level__c, Garage
mls_id__c, 421517266
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-04-14
original_price__c, 1150000
overall_days_on_market__c, 61
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,See Remarks
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-04-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1247.31
pba__propertytype__c, Single Family Residence
id, a0E1I00000TymWXUAZ
roof__c, Composition
room_type__c, Bonus Room;Attic;Workshop
sale_date__c, 2021-05-17
sale_price__c, 1508000
selling_agent_mls_id__c, 804035
selling_agent_number__c, 166013451
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Legacy Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1209
size__c, 1209
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Emmett
subdist__c, Bernal Heights
ffd_name, 190 Emmett Court, San Francisco, CA, 94110
view__c, City;City Lights;Garden/Greenbelt;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530218712-1.jpg
ListingId, a0E1I00000TymWXUAZ
