meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='234631' 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, 990 Guerrero Street, San Francisco, CA, 94110
ffd_mls_id, 421609377
ffd_salesforce_id, a0E8W00000V3L9YUAV
num_of_fireplaces__c, 2
num_of_rooms__c, 7
of_units__c, 3
address2__c, 990 Guerrero Street, San Francisco, CA, 94110
pba__address_pb__c, 990 Guerrero Street, San Francisco, CA, 94110
agent_only_remarks__c, Please contact Kate Stephenson for all showings,415.370.6531, [email protected]. Disclosures available including current inspections. HOA monthly dues are $646/month and include water, refuse collection, building insurance, landscaping, common area repairs & maintenance, fire alarm monitoring service, outside management. Two pets allowed; pet weight limit in CC&Rs is 35 lbs, however an exception was made for current owner's dog who weighs significantly more. No pre-emptive offers, please, per client instructions. Offer date/time: Monday, Feb.7 at 2PM. www.990Guerrero.com.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;Wine Refrigerator;Gas Cook Top
architectural_style__c, Contemporary;Victorian
bath_features__c, Tub w/Shower Over;Double Sinks;Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1890
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-01-25T11:50:45.000+0000
days_on_market__c, 541
dom__c, 16
ffd_description_pb, Grand & handsome full-floor condo, transformed with an open floor plan & modern conveniences, the flat retains just the right blend of original architectural details to lend significant character & warmth. The fabulous social space encompasses all the principal rooms. From the entry foyer & throughout, high ceilings, tall windows, thoughtfully curated light fixtures, custom closets & Victorian fireplaces add to the polished interior. The stunningly beautiful facade delivers enviable street presence. Impressive chef's gas kitchen with island & white high-gloss cabinetry, open dining room & generous living room. There are 4 bedrooms (including primary suite with small deck), 2.5 baths, laundry. Radiant heat. Includes deeded stacker parking, the top/ideal drive-in spot. Located near neighborhood jewel Dolores Park known for its skyline views, playground & sports courts; close to shopping and dining in the Castro & Mission Districts.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning;Decorative Only;Master Bedroom
pba__floortype_pb__c, Tile;Simulated Wood;Stone
hoa_fee_includes__c, Common Areas,Insurance,Insurance on Structure,Maintenance Exterior,Management,Security,Sewer,Trash,Water
pba__hoafees__c, 646
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 998-992 Guerrero Street
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant;Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-03-12T11:51:26.000+0000
pba__latitude_pb__c, 37.755364
pba__latitude_property__c, 37.755364
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2021-11-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rebecca
pba__listing_agent_lastname__c, Schumacher
listing_agent_mls_id__c, 805929
ffd_listingagentname, Rebecca Schumacher
listing_agent_number__c, 166016017
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 2495000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.990guerrero.com
pba__longitude_pb__c, -122.423547
mls_id__c, 421609377
main_level__c, Full Bath(s);Master Bedroom;Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Window
master_property__c, a0O8W00000DagtyUAB
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-01-24
original_price__c, 2495000
overall_days_on_market__c, 190
parking_access__c, Independent
parking_features__c, Alley Access,Mechanical Lift,Uncovered Parking Space
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-02-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-03-11T13:13:08.000+0000
price_per_square_foot__c, 1358.77
pba__propertytype__c, Condominium
id, a0E8W00000V3L9YUAV
room_type__c, Laundry;Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom
sale_date__c, 2022-03-11
sale_price__c, 2867000
selling_agent_mls_id__c, MLSL5083086
selling_agent_number__c, 981349414
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, FlyHomes, Inc
pba__status__c, Closed
pba__totalarea_pb__c, 2110
size__c, 2110
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Guerrero
subdist__c, The Castro - Dolores Heights
ffd_name, 990 Guerrero Street, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1890
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530390624-1.jpg
ListingId, a0E8W00000V3L9YUAV