meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='236989' 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, 2 Fair Oaks Street #2, San Francisco, CA, 94110
ffd_mls_id, 422661715
ffd_salesforce_id, a0E8W00000WjX2SUAV
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 4
address2__c, 2 Fair Oaks Street #2, San Francisco, CA, 94110
pba__address_pb__c, 2 Fair Oaks Street #2, San Francisco, CA, 94110
agent_only_remarks__c, This is an undivided 18.26% interest in 2 Fair Oaks, a 4-unit building. Buyers are advised to test park their car in the garage. PRIVATE SHOWINGS via calendly: https://calendly.com/teamhowe/showing-at-2-fair-oaks-street-?month=2022-05 DISCLOSURES: https://app.disclosures.io/link/2-Fair-Oaks-Street-2-d96fx4mj OFFERS: Wed 6/1 @ 10am.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Wine Refrigerator;Ice Maker;Built-In Refrigerator
bath_features__c, Tile;Dual Flush Toilet;Window;Multiple Shower Heads
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1929
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Savinie Lam
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-05-21T00:50:13.000+0000
days_on_market__c, 425
dom__c, 12
ffd_description_pb, Elegance, high ceilings, and period details are paired with modern luxury and a prized Dolores Heights location. This 2BR/1BA/1PK flat offers a recently remodeled eat-in kitchen w/ sleek finishes, graceful waterfall countertops, high-end appliances, and built-in wine refrigerator. Across the hall is a bedroom enjoying morning sunlight from east-facing windows and containing a large walk-in closet. A bright living room features a generous tray ceiling with ornate period molding and east and south-facing windows offering great views and natural light. Double doors open into the adjacent primary bedroom which boasts a huge closet with pullout jewelry trays and shoe racks. The unit is completed by a luxurious updated bathroom, stacked in-unit laundry closet, and a private 1-car garage. This desirable location lies at the crossroads of some of the city's best-known commercial hubs, providing world-class dining and shopping in every direction.
district__c, SF District 5
electric__c, 220 Volts
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance,Management,Sewer,Trash,Water
pba__hoafees__c, 593
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 2 Fair Oaks Street
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant;Fireplace(s)
ffd_lastmodifieddate, 2023-07-13T17:10:56.000+0000
pba__latitude_pb__c, 37.7565092
pba__latitude_property__c, 37.7565092
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-04-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sherri
pba__listing_agent_lastname__c, Howe
listing_agent_mls_id__c, 806718
ffd_listingagentname, Sherri Howe
listing_agent_number__c, 166017501
listing_co_agent_mls_id__c, 814525
listing_co_agent_number__c, 1066691
listing_co_office_mls_id__c, BRAVA
listing_co_office_name__c, Brava Real Estate
listing_co_office_number__c, 28638
listing_office_mls_id__c, BRAVA
listing_office_name__c, Brava Real Estate
listing_office_number__c, 28638
pba__listingprice_pb__c, 1099000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=SgMEk9CdRuE&mls=1
pba__longitude_pb__c, -122.4246034
mls_id__c, 422661715
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-05-20
original_price__c, 1099000
overall_days_on_market__c, -81223
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage Facing Front,Private
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2022-06-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1130.83
pba__propertytype__c, Tenancy In Common
record_id, a0E8W00000WjX2SUAV
sale_date__c, 2022-07-13
sale_price__c, 1115000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 815130
selling_agent_number__c, 1071055
selling_co_agent_mls_id__c, 814039
selling_co_agent_number__c, 1064166
selling_co_office_mls_id__c, AVNU
selling_co_office_name__c, Avenue 8 Inc.
selling_co_office_number__c, 28244
selling_office_name__c, Avenue 8 Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 986
size__c, 986
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fair Oaks
subdist__c, The Castro - Dolores Heights
ffd_name, 2 Fair Oaks Street #2, San Francisco, CA, 94110
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1929
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530463147-1.jpg
ListingId, a0E8W00000WjX2SUAV