meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327026' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15719
[post_author] => 4
[post_date] => 2018-11-02 19:54:35
[post_date_gmt] => 2018-11-02 19:54:35
[post_content] => Russian sailors were once buried upon this hill. That's why. Ground zero for the San Francisco high-rise revolt that began in the 1960s. Not coincidentally, also home to The Summit, The Royal Towers, Green Hill Tower, the so-called crookedest street in SF (the real crookedest street is in Potrero Hill), and the authentic inspiration for Armistead Maupin's magical Barbary Lane.
[post_title] => Russian Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => russian-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-14 03:40:15
[post_modified_gmt] => 2022-12-14 11:40:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15719
[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, 1237 Chestnut Street #4, San Francisco, CA, 94109
ffd_mls_id, 423721815
ffd_salesforce_id, a0E8W00000bEyTJUA0
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 6
address2__c, 1237 Chestnut Street #4, San Francisco, CA, 94109
pba__address_pb__c, 1237 Chestnut Street #4, San Francisco, CA, 94109
agent_only_remarks__c, Parking can be leased in the building for $250. Vehicle must be no greater than 73"W x 178"L-mirrors must fold to fit. Disclosures are in process, please email requests. Escrow open with Katerina Rosignuolo at DOMA Title.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range
architectural_style__c, Edwardian
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1923
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-03T11:49:28.000+0000
days_on_market__c, 27
dom__c, 27
ffd_description_pb, Quintessential San Francisco Living, this spacious 2BD/2BA classic Edwardian Condo located in Russian Hill offers views of GG Bridge. This home features traditional period details, high ceilings, southern facing bay windows, views of GG Bridge from the primary bedroom & living room, hardwood floors throughout & new light fixtures- these are just a few of the features that you'll treasure. The kitchen has custom cabinetry, SS appliances & stackable W/D. The primary bedroom has a large en suite bath with a double vanity & a walk in rain shower. 2nd Bedroom can also be used as a formal dining room. There is also a 2nd full bathroom to complete this beautiful home. Deeded storage in garage and shared backyard with BBQ. Parking is assigned by tenure in bldg. 6 units with 5 parking spots. The next sale in the bldg. will get the space. Exceptional location- you have it all, close to Polk St. restaurants/shopping. Close to brand new Francisco Park, Aquatic Park, Fort Mason, North Beach and GG Bridge. On a quiet block and located close to everything you will need. Low HOA- $425
district__c, SF District 8
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Heat,Maintenance Grounds,Trash,Water
pba__hoafees__c, 425
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1237 Chestnut Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Steam
ffd_lastmodifieddate, 2023-03-30T10:48:16.000+0000
pba__latitude_pb__c, 37.8021928
pba__latitude_property__c, 37.8021928
laundry_features__c, In Kitchen;Washer/Dryer Stacked Included
listed_date__c, 2023-02-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Elizabeth
pba__listing_agent_lastname__c, Marroquin
listing_agent_mls_id__c, 803496
ffd_listingagentname, Lisa M Marroquin
listing_agent_number__c, 803496
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, PKNO
listing_office_name__c, Park North Real Estate
listing_office_number__c, 24343
pba__listingprice_pb__c, 1325000
pba__listingtype__c, Sale
pba__listing_website__c, https://matterport.com/discover/space/9w6ga6KBRqc
pba__longitude_pb__c, -122.423751
mls_id__c, 423721815
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Double Sinks
master_property__c, a0O1I000001ViRtUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-03-03
open_house_end__c, 2023-04-01T15:00:00.000+0000
open_house_start__c, 2023-04-01T13:00:00.000+0000
original_price__c, 1325000
overall_days_on_market__c, -81510
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, 1061.7
pba__propertytype__c, Condominium
ListingId, a0E8W00000bEyTJUA0
roof__c, Elastomeric
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
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, 1248
size__c, 1248
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Chestnut
subdist__c, Russian Hill
ffd_name, 1237 Chestnut Street #4, San Francisco, CA, 94109
view__c, Golden Gate Bridge
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530580953-1.jpg
