meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329199' 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] => 2022-12-05 06:03:10
[post_modified_gmt] => 2022-12-05 14:03:10
[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, 3057 Market 3059 Street #3059, San Francisco, CA, 94114
ffd_mls_id, 423715307
ffd_salesforce_id, a0E8W00000a6zwVUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 3057 Market 3059 Street #3059, San Francisco, CA, 94114
pba__address_pb__c, 3057 Market 3059 Street #3059, San Francisco, CA, 94114
agent_only_remarks__c, Offers to be reviewed as received*** Disclosure Package Available per Request*** Please email BOTH [email protected] & [email protected] for disclosures or private showings*** Only use SFAR Purchase Contract. On the purchase contract, stipulate that buyer's deposit will be in escrow within one (1)business day of acceptance. Escrow has been opened at First American Title with Mijael Schmidt. | See more at www.ModernCastroLiving.com
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1958
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Alan Martinez
pba__contingentdate__c, 2023-01-23
cooling__c, None
ffd_createddate, 2023-01-13T11:48:31.000+0000
days_on_market__c, 81
dom__c, 80
ffd_description_pb, Welcome home to Castro Modern. This designer-curated, fully-renovated residence is situated in the geographical center of San Francisco. This sleek TIC, in a two-unit association (fast-track conversion eligible), boasts a modern open floor plan, a custom kitchen with a top-of-the-line appliance suite, in-unit laundry, independent vehicle parking, a luxuriously landscaped private garden, all while showcasing exquisite design sensibility. Smart home features include Nest-controlled central heating, Ring video entry, and keycode access to the moody lobby for convenient package management. Castro Modern offers its residents sophisticated, thoughtful luxury, all while being centrally located just a few blocks away from the Castro District with its lively boutique restaurant and shopping scene, access to multiple MUNI bus & rail routes and tech shuttle stops, and live entertainment. | See more at ModernCastroLiving.com
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 250
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-04-04T00:48:12.000+0000
pba__latitude_pb__c, 37.760874
pba__latitude_property__c, 37.760874
laundry_features__c, Hookups Only
listed_date__c, 2023-01-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jonathan
pba__listing_agent_lastname__c, Deason
listing_agent_mls_id__c, 807058
ffd_listingagentname, Jonathan B Deason
listing_agent_number__c, 166018127
listing_co_agent_mls_id__c, 813651
listing_co_agent_number__c, 1062611
listing_co_office_mls_id__c, VANG03
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 1228
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.moderncastroliving.com
pba__longitude_pb__c, -122.442303
mls_id__c, 423715307
master_bathroom_features__c, Double Sinks;Marble;Multiple Shower Heads;Dual Flush Toilet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-13
original_price__c, 1195000
overall_days_on_market__c, -81461
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-04-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1004.2
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000a6zwVUAQ
sale_date__c, 2023-04-03
sale_price__c, 1195000
selling_agent_mls_id__c, 807893
selling_agent_number__c, 1028221
selling_co_agent_mls_id__c, 806933
selling_co_agent_number__c, 166017897
selling_co_office_mls_id__c, VANTAGE
selling_co_office_name__c, Vantage Realty
selling_co_office_number__c, 28995
selling_office_name__c, Vantage Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1190
size__c, 1190
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Market
subdist__c, The Castro - Dolores Heights
ffd_name, 3057 Market 3059 Street #3059, San Francisco, CA, 94114
website_property_type__c, Tenancy In Common
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1958
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530568371-1.jpg