meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212133' 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, 533 Noe Street, San Francisco, CA, 94114
ffd_mls_id, 496649
ffd_salesforce_id, a0E1I00000SKc1iUAD
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 0
address2__c, 533 Noe Street, San Francisco, CA, 94114
pba__address_pb__c, 533 Noe Street, San Francisco, CA, 94114
agent_only_remarks__c, COVID compliant showings by appointment. Please call or text Gael, 415.309.9094 to schedule. Pre-escrow open with Old Republic Title Company, Helen Dumont. Also see www.NoeStVictorian.com
appliances__c, Dishwasher;Gas Range;Refrigerator
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Marble
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-06-15T10:45:32.000+0000
days_on_market__c, 1129
dom__c, 19
ffd_description_pb, Classic 4 bedroom, 3.5 bath Italianate Victorian has the polish and allure of quintessential San Francisco. High ceilings, hardwood floors, period architectural details and large rooms that provide for open and inviting living. Step out to a deck that overlooks that landscaped garden and enjoy peek-a-boo views of the downtown city skyline. 3 bedrooms, 2 marble baths on the upper level, the master en suite. The lower level functions as a guest suite, in law, or Airbnb. 1 car garage, workshop area, laundry and attic storage. Located in the heart of Eureka Valley and just off the beaten path with unrivaled access to world class restaurants, shops, nightlife and transportation.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Decorative Only;Dining Room
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:21:45.000+0000
pba__latitude_pb__c, 37.76051
pba__latitude_property__c, 37.76051
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-03-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gael
pba__listing_agent_lastname__c, Bruno
listing_agent_mls_id__c, 803912
ffd_listingagentname, Gael Bruno
listing_agent_number__c, 166013274
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, 3395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.43242
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s),Living Room
mls_id__c, 496649
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-06-15
original_price__c, 3600000
overall_days_on_market__c, 107
parking__c, Garage,Interior Access
parking_access__c, Independent
parking_features__c, Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-07-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1178.51
pba__propertytype__c, Single Family Residence
id, a0E1I00000SKc1iUAD
room_type__c, Den
sale_date__c, 2020-07-14
sale_price__c, 3400000
selling_agent_mls_id__c, 809011
selling_agent_name__c, Craig L. Epstein
selling_agent_number__c, 1039716
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2885
size__c, 2885
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Noe
subdist__c, The Castro - Dolores Heights
ffd_name, 533 Noe Street, San Francisco, CA, 94114
transportation__c, 1 Block
view__c, Garden/Greenbelt;Partial;Downtown
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362649-1.jpg
ListingId, a0E1I00000SKc1iUAD