meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='335481' 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] => 2023-09-21 11:43:21
[post_modified_gmt] => 2023-09-21 18:43:21
[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, 223 Richland Avenue, San Francisco, CA, 94110
ffd_mls_id, 423748300
ffd_salesforce_id, a0E8W00000cJT8DUAW
num_of_fireplaces__c, 1
num_of_rooms__c, 12
of_units__c, 0
address2__c, 223 Richland Avenue, San Francisco, CA, 94110
pba__address_pb__c, 223 Richland Avenue, San Francisco, CA, 94110
agent_only_remarks__c, Disclosures: https://app.disclosures.io/link/223-Richland-Ave-3my2ps83 Upstairs loft area is ready for viewing!
appliances__c, Dishwasher;Built-In Gas Range;Free Standing Refrigerator;Double Oven
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1904
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sam Buckwalter
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-06-14T19:48:44.000+0000
days_on_market__c, 35
dom__c, 16
ffd_description_pb, Expansive updated residence near Holly Park in the sought after Bernal Heights neighborhood. This remarkable home offers an expansive layout with 4+ BD and two additional developed spaces. Step inside and be captivated by the grand corridor with soaring ceilings and stunning hardwood floors. The family room seamlessly connects to a spacious dining room, perfect for entertaining and creating cherished memories. The well-appointed kitchen, laundry room, and sunroom/home office provide convenience and comfort. Upstairs, you'll find four tranquil bedrooms and a full bath. The fully developed third level loft offers two additional bedrooms with sweeping southern views, a living room and a bath with separate entrances. The bottom level features a bedroom, den, bath, and a separate entrance. Step outside to the backyard oasis with fruit trees, ideal for al fresco dining and relaxation. With a Walkscore of 87, enjoy nearby Cofeta coffee shop, Holly Park, St Mary Park, tennis courts, Cortland Avenue's vibrant hot spots, Alemany Farmer's Market, and easy access to Glen Park BART, MUNI, tech shuttles, and highways. A large garage adds practicality. Embrace the space, charm, and possibilities of this remarkable Bernal Heights residence.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Wood;Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-07-15T10:47:57.000+0000
pba__latitude_pb__c, 37.736108
pba__latitude_property__c, 37.736108
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2023-06-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Renee
pba__listing_agent_lastname__c, Gonsalves
listing_agent_mls_id__c, 803247
ffd_listingagentname, Renee M Gonsalves
listing_agent_number__c, 803247
listing_co_agent_mls_id__c, 816683
listing_co_agent_number__c, 1075634
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2150000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.422362
lower_level__c, Street Entrance,Retreat,Garage
mls_id__c, 423748300
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-06-14
original_price__c, 2150000
overall_days_on_market__c, -81613
parking_access__c, Independent
parking_features__c, Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-06-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-07-14T16:57:30.000+0000
price_per_square_foot__c, 738.64
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cJT8DUAW
room_type__c, Bonus Room;Sun Room;In Law Apartment;Attic
sale_date__c, 2023-07-14
sale_price__c, 1950000
selling_agent_mls_id__c, 364925
selling_agent_number__c, 364925
selling_co_agent_mls_id__c, 390429
selling_co_agent_number__c, 390429
selling_co_office_mls_id__c, COMP7
selling_co_office_name__c, Compass
selling_co_office_number__c, 28751
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2640
size__c, 2640
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Richland
subdist__c, Bernal Heights
ffd_name, 223 Richland Avenue, San Francisco, CA, 94110
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530631018-1.jpg
