meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210180' posts_per_page=4 post_type=property
int(1)
Array
(
[ID] => 15603
[post_author] => 4
[post_date] => 2018-11-02 02:29:53
[post_date_gmt] => 2018-11-02 02:29:53
[post_content] => Liberty Hill. The sweet, sweet homes surrounding Dolores Park. Gaze at the downtown skyline after a walk through Dolores Park with the pooch. Not quite Noe Valley or the Castro and rising above Mission Dolores, Dolores Heights is home to some of central San Francisco's most expensive real estate.
[post_title] => Dolores Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dolores-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-05 06:03:10
[post_modified_gmt] => 2022-12-05 14:03:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15603
[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 207 Eureka Street, San Francisco, CA, 94114
ffd_mls_id 495120
ffd_salesforce_id a0E1I00000RM5EiUAL
num_of_fireplaces__c 1
num_of_rooms__c 6
of_units__c 3
address2__c 207 Eureka Street, San Francisco, CA, 94114
pba__address_pb__c 207 Eureka Street, San Francisco, CA, 94114
agent_only_remarks__c For questions and interest please call Listing Agent 415-407-8796 . Very casual 3 Unit HOA. They handle expenses as they come up and they collect $250 a month to cover basics (garbage, water etc). Open escrow with Elisabeth Davis at Fidelity National @ (415) 874-4425. If writing an offer, please call Listing Agent and use SFAR Purchase Agreement (we are happy to provide if needed), proof of funds for cash offers or pre-approval letter along with signed disclosure cover sheet.
appliances__c Dishwasher;Gas Range;Refrigerator;Hood Over Range
architectural_style__c Edwardian
bath_features__c Tub w/Shower Over;Remodeled;Radiant Heat
pba__fullbathrooms_pb__c 1
pba__bedrooms_pb__c 3
year_build_text__c 1917
pba__city_pb__c San Francisco
listing_co_agent_name__c Richard Lester
pba__contingentdate__c 1800-01-01
ffd_createddate 2020-02-21T11:46:33.000+0000
days_on_market__c 972
dom__c 9
ffd_description_pb 1st time on the market in 25 years ~ This handsome top floor 3BR | 1BA condominium with 1 car garage is in a super-prime Castro location and offers the perfect blend of style and convenience. Set atop a fully detached 3-unit building with windows on all 4 sides your new home is flooded with natural light and brilliant San Francisco views. Rich Edwardian period-details include a classic brick fireplace that's wood-burning, elegant formal dining room w/ graceful french doors, large picture windows and ~ 9 ft ceilings. Stylishly updated bathroom with heated floors, remodeled eat-in kitchen with Salesforce views and laundry room with walk-up to vintage roof deck. Remarkable layout has a distinctly circular flow that's perfect for memorable entertaining. 207 Eureka is in an ideal location that's close to top rated dining, entertainment & shopping (98 walk score) and easy transportation access (90 transit score). Welcome home to your Eureka Dream.
district__c SF District 5
entry_level__c 3
external_listing__c 1
fireplace_features__c Living Room;Wood Burning
pba__floor__c 3
pba__floortype_pb__c Carpet;Wood
hoa_dues__c 250
pba__hoafees__c 250
pba__hoafrequency_pb__c Monthly
hoa_name__c 207-209-211 Eureka Street Homeowners Ass
hoa__c Yes
pba__halfbathrooms_pb__c 0
pba__heatingtype_pb__c Central;Gas
ffd_lastmodifieddate 2022-01-12T15:28:11.000+0000
pba__latitude_pb__c 37.75887
pba__latitude_property__c 37.75887
laundry_appliances__c Washer/Dryer,In Laundry Room
laundry_features__c Inside Room;Washer/Dryer Included
listed_date__c 2019-11-06
pba__listing_agent_email__c connect@mycitycountry.com
pba__listing_agent_firstname__c John
pba__listing_agent_lastname__c Genovese
listing_agent_mls_id__c 803482
ffd_listingagentname John J Genovese
listing_agent_number__c 803482
listing_co_agent_mls_id__c B327864
listing_co_agent_number__c 981113016
listing_co_office_mls_id__c 7B714
listing_co_office_name__c Vanguard Properties
listing_co_office_number__c 981034269
listing_office_mls_id__c VANG03
listing_office_name__c Vanguard Properties
listing_office_number__c 1228
pba__listingprice_pb__c 1494000
pba__listingtype__c Sale
pba__listing_website__c http://www.EurekaDream.com
pba__longitude_pb__c -122.43794
pba__lotsize_pb__c 0
mls_id__c 495120
main_level__c Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c a0O1I000008oqixUAA
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 1
on_market_date__c 2020-02-21
original_price__c 1494000
overall_days_on_market__c 100
parking_access__c Independent
parking_features__c Attached,Garage Door Opener,Garage
parking_type__c On Site - Mapped (Condo Only)
pba__pendingdate__c 2020-03-01
possible_bedrooms__c 0
pba__pricechangedat__c 1800-01-01T00:00:00.000+0000
price_per_square_foot__c 1319.78
pba__propertytype__c Condominium
id a0E1I00000RM5EiUAL
sale_date__c 2020-03-20
sale_price__c 1655000
selling_agent_mls_id__c 813231
selling_agent_name__c Christopher Stein
selling_agent_number__c 1060338
selling_co_agent_mls_id__c 804303
selling_co_agent_name__c Dan Dodd
selling_co_agent_number__c 166013815
selling_co_office_mls_id__c COMP
selling_co_office_name__c Compass
selling_co_office_number__c 26293
selling_office_name__c Compass
pba__status__c Closed
pba__totalarea_pb__c 1254
size__c 1254
pba__state_pb__c CA
stories__c 0
pba__street_pb__c Eureka
subdist__c The Castro - Dolores Heights
ffd_name 207 Eureka Street, San Francisco, CA, 94114
transportation__c 1 Block
view__c Partial;Downtown
website_property_type__c Condominium
pba__yearbuilt_pb__c 1917
pba__postalcode_pb__c 94114
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/360589-1.jpg
ListingId a0E1I00000RM5EiUAL