meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219288' 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, 75 Justin Drive, San Francisco, CA, 94112
ffd_mls_id, 421558841
ffd_salesforce_id, a0E1I00000UU7u2UAD
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 75 Justin Drive, San Francisco, CA, 94112
pba__address_pb__c, 75 Justin Drive, San Francisco, CA, 94112
agent_only_remarks__c, OFFER Date: June 22 @ 10:00 AM. No pre-emptives please. This is a trust sale (no court confirmation) and an As-Is sale. Disclosure Package is available. Pre-escrow opened with Chicago Title, Barbara Jimenez #3652100535. Seller reserves the right to accept, reject, and counter any and all offers. Questions - call/text Kelly Quon @ 415-244-1798, [email protected].
appliances__c, Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Shower Stall(s);Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1927
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sabrina Gee-Shin
pba__contingentdate__c, 2021-06-22
ffd_createddate, 2021-06-11T10:50:03.000+0000
days_on_market__c, 768
dom__c, 13
ffd_description_pb, Within the prized St. Mary's Park bell stands 75 Justin Drive, the beloved home that has served generations of family. On the market for the first time in over 40 years, this beautiful and fully detached, single family home has great natural light, charming architectural details, living room view of hills, and a rear yard. The main level has 2 bedrooms, 1 bathroom, a formal dining room and spacious living room with fireplace. The kitchen connects to a bright breakfast nook that overlooks the backyard. The garage level provides plenty of space for storage, work-out gym, and home office. The neighborhood is tight-knit and has activities year-round including Easter egg hunts, block parties, garage sales, 4th of July parade, and Halloween contest. Home is adjacent to the St. Mary's Recreation Center that has a gym, athletic field, playground, tennis courts and dog play area. Close to shopping & dining on Cortland Ave., Mission St., Glen Park and Noe Valley. Near Glen Park BART, 280 & 101.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Linoleum;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:54:14.000+0000
pba__latitude_pb__c, 37.734218
pba__latitude_property__c, 37.734218
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-04-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kelly
pba__listing_agent_lastname__c, Quon Lutz
listing_agent_mls_id__c, 810315
ffd_listingagentname, Kelly Quon Lutz
listing_agent_number__c, 1045621
listing_co_agent_mls_id__c, 804986
listing_co_agent_number__c, 166014733
listing_co_office_mls_id__c, CGL06
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28275
listing_office_mls_id__c, CGL06
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28275
pba__listingprice_pb__c, 1068000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/560284439
pba__longitude_pb__c, -122.422361
lower_level__c, Garage
mls_id__c, 421558841
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, 2021-06-11
original_price__c, 1068000
overall_days_on_market__c, 92
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-06-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1243.64
pba__propertytype__c, Single Family Residence
id, a0E1I00000UU7u2UAD
room_type__c, Storage;Kitchen;Living Room;Dining Room;Master Bedroom
sale_date__c, 2021-07-19
sale_price__c, 1710000
selling_agent_mls_id__c, 802259
selling_agent_number__c, 802259
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Generation Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1375
size__c, 1375
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Justin
subdist__c, Bernal Heights
ffd_name, 75 Justin Drive, San Francisco, CA, 94112
view__c, Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1927
pba__postalcode_pb__c, 94112
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530256214-1.jpg
ListingId, a0E1I00000UU7u2UAD