meta_query='key:subdist__c;value:Bernal Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='383302' 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
(
)
)
_yoast_indexnow_last_ping, 1726174585
ffd_listing_title, 308 Coleridge Street, San Francisco, CA, 94110
ffd_mls_id, 424039938
ffd_salesforce_id, a0EUd000002kqaMMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 7
address2__c, 308 Coleridge Street, San Francisco, CA, 94110
pba__address_pb__c, 308 Coleridge Street, San Francisco, CA, 94110
agent_only_remarks__c, Private showings by scheduled appointment, please call/text Jennifer: (415) 779-4651. Visit www.ViewsonColeridge.com for more info and floorplans. HOA dues include radiant heat, hot water, Google Fiber internet, water, sewer, trash, bookkeeping, HOA insurance and scheduled window cleanings. Parking is side-by-side - only 2 units in building have parking. Square footage is 1022 Sq. Ft., per prior MLS.
appliances__c, Dishwasher;Microwave
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Radiant Heat
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1910
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Ron Wong
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-08-02T22:49:14.000+0000
days_on_market__c, 41
dom__c, 41
ffd_description_pb, Experience comfort and luxury in this top-floor urban retreat in desirable North-West Bernal Heights. 2 bed / 1 bath unit with gorgeous finishes and expansive views of Twin Peaks, Downtown, Bay Bridge and city lights. Full of natural sun, the open concept living area features beautiful outlooks, skylights and wide plank white oak floors. The heart of the home holds a chef's kitchen - anchored by a large center island w/elegant cabinetry, Bertazzoni range and Bosch dishwasher. Remodeled bathroom with deep tub and floating vanity. Two good sized bedrooms with Elfa closet systems. Radiant heat throughout, in-unit LG washer & dryer, and Ecobee thermostat, Kasa smart switches, Nest camera at security gate. Part of a boutique 7-unit building remodeled in 2017 w/earthquake & foundation work, with secure mailbox, dedicated storage and generous side by side parking with a 220V EV outlet. Blocks from Bernal's best parks, Four Chairs and Chisai Sushi Club, and walkable to Cortland, Valencia and 24th. Minutes to 101 & 280, convenient access to shuttles and MUNI. HOA dues cover heat, hot water, gfiber internet, water, trash, bookkeeping, HOA insurance, window cleanings, and parking.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Heat,Insurance,Insurance on Structure,Internet,Management,Sewer,Trash,Water,See Remarks
pba__hoafees__c, 772
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-09-12T20:47:26.000+0000
pba__latitude_pb__c, 37.7417191
pba__latitude_property__c, 37.7417191
listed_date__c, 2024-05-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jennifer
pba__listing_agent_lastname__c, Gottlieb
listing_agent_mls_id__c, 813928
ffd_listingagentname, Jennifer Gottlieb
listing_agent_number__c, 1063398
listing_co_agent_mls_id__c, 806373
listing_co_agent_number__c, 164505277
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP90
listing_office_name__c, Compass
listing_office_number__c, 29048
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.ViewsOnColeridge.com
pba__longitude_pb__c, -122.4211577
mls_id__c, 424039938
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-08-02
open_house_end__c, 2024-09-15T16:00:00.000+0000
open_house_start__c, 2024-09-15T14:00:00.000+0000
original_price__c, 1095000
overall_days_on_market__c, -82028
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,EV Charging,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1071.43
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd000002kqaMMAQ
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Video System
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1022
size__c, 1022
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Coleridge
subdist__c, Bernal Heights
ffd_name, 308 Coleridge Street, San Francisco, CA, 94110
view__c, City;City Lights;Downtown;Bay Bridge;San Francisco;Twin Peaks
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530791415-1.jpg