meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330012' 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-03-19 13:49:28
[post_modified_gmt] => 2024-03-19 20:49:28
[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, 2811 Market Street, San Francisco, CA, 94114
ffd_mls_id, 423723531
ffd_salesforce_id, a0E8W00000bEZy9UAG
num_of_fireplaces__c, 0
num_of_rooms__c, 2
of_units__c, 4
address2__c, 2811 Market Street, San Francisco, CA, 94114
pba__address_pb__c, 2811 Market Street, San Francisco, CA, 94114
agent_only_remarks__c, 2 room condominium in the heart of the Castro - this one is gorgeous! Transparently priced and ready to sell. Deeded, private garage parking. Updated kitchen and remodeled bath. Modern updates blended with period detail - unique and inviting! Prelim courtesy of Gerrie Brindley at Chicago Title.
appliances__c, Dishwasher;Microwave;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Tile;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-03-24
cooling__c, None
ffd_createddate, 2023-02-24T18:48:10.000+0000
days_on_market__c, 145
dom__c, 42
ffd_description_pb, Set in a 1922 Edwardian building packed with period charm, 2811 Market Street is a well laid-out, cleverly designed studio. This top-floor corner unit is bathed in light from three sides and beloved for many reasons: its amazing location in the Castro District, spacious kitchen and dining area, quaint historic features, congenial community, and stunning views including Eureka Valley to the west and the Caselli Mansion to the south. Original trim combines with hardwood floors to create an outstanding ambiance while a stunning remodeled kitchen boasts all stainless-steel appliances and maple cabinetry - a culinary artist's dream! Completing the package are a private single-car garage, extra basement storage, and a well-run homeowners' association. 2811 Market is set in one of the city's most hotly desired areas - the Castro is world-renowned for its historic emphasis on embracing exactly who you are. When you come home here, you're doing exactly that.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Insurance,Maintenance Exterior,Trash,Water
pba__hoafees__c, 300
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 2805-2811 Market St HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard
ffd_lastmodifieddate, 2023-07-13T18:27:34.000+0000
pba__latitude_pb__c, 37.761176
pba__latitude_property__c, 37.761176
laundry_features__c, In Basement
listed_date__c, 2023-01-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Brendon
pba__listing_agent_lastname__c, Kearney
listing_agent_mls_id__c, 802979
ffd_listingagentname, Brendon Kearney
listing_agent_number__c, 802979
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 695000
pba__listingtype__c, Sale
pba__listing_website__c, https://mls.ricoh360.com/b3efc441-7729-4874-8240-20b07087bc55/c255722f-7ed3-476d-85a3-bad3307a7523
pba__longitude_pb__c, -122.439582
mls_id__c, 423723531
main_level__c, Full Bath(s);Kitchen;Living Room
master_property__c, a0O8W00000HtCMKUA3
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-02-24
original_price__c, 695000
overall_days_on_market__c, -81503
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Private
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-04-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1123.13
pba__propertytype__c, Condominium
ListingId, a0E8W00000bEZy9UAG
room_type__c, Kitchen;Living Room;Baths Other
sale_date__c, 2023-04-18
sale_price__c, 675000
security_features__c, Security Gate
selling_agent_mls_id__c, 815001
selling_agent_number__c, 1069788
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, City Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 601
size__c, 601
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Market
subdist__c, The Castro - Dolores Heights
ffd_name, 2811 Market Street, San Francisco, CA, 94114
view__c, City;City Lights;Twin Peaks
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530583806_7fee899a-1594-4fca-a3a2-10005968e6fe.jpg