meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215580' 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, 31 Justin Drive, San Francisco, CA, 94112
ffd_mls_id, 508309
ffd_salesforce_id, a0E1I00000TTKbXUAX
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 31 Justin Drive, San Francisco, CA, 94112
pba__address_pb__c, 31 Justin Drive, San Francisco, CA, 94112
agent_only_remarks__c, COVID Compliant Showings so please submit PEAD docs prior to entry. Please schedule showings with John Kenny (650) 678-7761 Pre-Escrow opened with Semiko Prim of Chicago Title.
appliances__c, Gas Range;Disposal;Refrigerator;Hood Over Range;Cooktop Stove;Freezer;Self/Cont Clean Oven
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1925
pba__city_pb__c, San Francisco
listing_co_agent_name__c, John Kenny
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-10-16T18:45:16.000+0000
days_on_market__c, 1006
dom__c, 39
ffd_description_pb, Buy it now! Includes Lower level BONUS ROOM/OFFICE & 2 updated Bathrooms! Amazing single family home located in one of the most coveted micro neighborhoods in San Francisco, St. Mary's Park Bernal Heights! This tastefully updated and fully detached home boasts an exceptional floor plan with updated lighting, paint and refinished hardwood floors. Enjoy the Beautiful south facing views from living room. Main level has a traditional layout with 2 bedrooms, 1 Bathroom on the main level which also includes Formal dining room, modern kitchen, breakfast nook with brand new high end Thermador Appliances. Backyard has been re-mastered with brand new concrete patio, fencing and landscaping which creates the perfect outdoor space! Garage includes brand new laundry area with ample storage and parking. SCHEDULE YOUR APPOINTMENT TODAY!
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Wood Burning;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;Gas
ffd_lastmodifieddate, 2022-01-25T15:37:58.000+0000
pba__latitude_pb__c, 37.7346789
pba__latitude_property__c, 37.7346789
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-10-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Brian
pba__listing_agent_lastname__c, Kelly
listing_agent_mls_id__c, 805876
ffd_listingagentname, Brian Kelly
listing_agent_number__c, 177517679
listing_co_agent_mls_id__c, 800922
listing_co_agent_number__c, 800922
listing_co_office_mls_id__c, C-BA
listing_co_office_name__c, Century 21 Baldini Realty
listing_co_office_number__c, 770
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 1649000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/468231248
pba__longitude_pb__c, -122.423115
pba__lotsize_pb__c, 0.09
mls_id__c, 508309
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-10-16
original_price__c, 1749000
overall_days_on_market__c, 92
parking__c, Garage,Interior Access
parking_features__c, Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-11-24
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, a0E1I00000TTKbXUAX
roof__c, Tile
room_type__c, Storage;Bonus Room
sale_date__c, 2020-12-21
sale_price__c, 1605000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 808958
selling_agent_name__c, Ryan Richard
selling_agent_number__c, 1038682
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, 0
pba__street_pb__c, Justin
subdist__c, Bernal Heights
ffd_name, 31 Justin Drive, San Francisco, CA, 94112
transportation__c, 1 Block
view__c, Panoramic;City Lights;San Francisco
website_property_type__c, Single Family Home
window_features__c, Bay Window(s);Dual Pane;Weather Stripped
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/372362-1.jpg
ListingId, a0E1I00000TTKbXUAX