meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235248' 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] => 2024-11-19 12:01:01
[post_modified_gmt] => 2024-11-19 20:01:01
[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, 274 Douglass Street, San Francisco, CA, 94114
ffd_mls_id, 422624287
ffd_salesforce_id, a0E8W00000Vtla8UAB
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 274 Douglass Street, San Francisco, CA, 94114
pba__address_pb__c, 274 Douglass Street, San Francisco, CA, 94114
agent_only_remarks__c, Full disclosure package available including home and pest inspections. Offers, if any, to be reviewed Thursday, March 10th at 2:00 p.m. Pre-escrow opened with Elisabeth Davis of Fidelity Nation Title. Square footage per tax records is 872 sq. ft.; floor plan measures at 975 sq. feet. Tax records show as a 1 bedroom condo. Previously marketed as a 2 bedroom when sellers purchased. Very flexible floor plan. Buyers to investigate to their satisfaction on all.
appliances__c, Microwave;Disposal;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Contemporary;Victorian
bath_features__c, Tub w/Shower Over;Marble;Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2022-03-08T19:51:18.000+0000
days_on_market__c, 1033
dom__c, 7
ffd_description_pb, A+ Location! Recently renovated full floor condo in Eureka Valley- adjacent to the Caselli Mansion (quiet part of the Castro); just blocks to amazing neighborhood amenities. Very flexible floor plan- use as a 1 or 2 bedroom unit. Upgrades include new hardwood flooring, painting throughout, new kitchen cabinets, countertop, sink & faucet, landscaping of beautiful, large garden, light fixtures, & custom shutters! The bathroom is modern w/ a double sink & marble counter. There is good storage in the dedicated garage areas. The kitchen has ample cabinet space for all necessities & is equipped with s/s appliances. It is attached to an open area that could easily be used as kitchen/living/dining area. Directly off the kitchen are sliding doors leading to a private deck. Beyond is the tranquil, spacious shared rear yard- perfect for entertaining! Dedicated washer/dryer in garage & 1 car tandem parking. Welcome home to this amazing condo w/ great flexibilty, located in a stellar location!
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Insurance on Structure,Trash,Water
pba__hoafees__c, 250
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 272-274 Douglass St. HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-04-14T01:47:50.000+0000
pba__latitude_pb__c, 37.759408
pba__latitude_property__c, 37.759408
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-01-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eric
pba__listing_agent_lastname__c, Rahe
listing_agent_mls_id__c, 806789
ffd_listingagentname, Eric T Rahe
listing_agent_number__c, 166017619
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 999000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.274douglass.com
pba__longitude_pb__c, -122.439492
mls_id__c, 422624287
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O8W00000EUVlUUAX
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-03-04
original_price__c, 999000
overall_days_on_market__c, -81146
parking_access__c, Tandem
parking_features__c, Attached,Tandem Garage
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Covered Deck
pba__pendingdate__c, 2022-03-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-04-13T12:17:30.000+0000
price_per_square_foot__c, 1451.28
pba__propertytype__c, Condominium
id, a0E8W00000Vtla8UAB
sale_date__c, 2022-04-13
sale_price__c, 1415000
selling_agent_mls_id__c, 811520
selling_agent_number__c, 1051920
selling_co_agent_mls_id__c, 807863
selling_co_agent_number__c, 1027872
selling_co_office_mls_id__c, COMP3
selling_co_office_name__c, Compass
selling_co_office_number__c, 27342
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 975
size__c, 975
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Douglass
subdist__c, The Castro - Dolores Heights
ffd_name, 274 Douglass Street, San Francisco, CA, 94114
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530412960-1.jpg
ListingId, a0E8W00000Vtla8UAB
_yoast_indexnow_last_ping, 1735676934