meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212985' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:14:15
[post_modified_gmt] => 2024-03-19 21:14:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[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, 1330 Hampshire Street, San Francisco, CA, 94110
ffd_mls_id, 500342
ffd_salesforce_id, a0E1I00000SxxG0UAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 2
address2__c, 1330 Hampshire Street, San Francisco, CA, 94110
pba__address_pb__c, 1330 Hampshire Street, San Francisco, CA, 94110
agent_only_remarks__c, Transparent pricing. Pre-escrow opened with Steve Salviejo, NAT. To schedule COVID-compliant showings of this vacant residence, for questions and disclosure requests please contact Mark Fry at 415.755.5685 or [email protected]. For more information, visit 1330hampshirest.com. Historically an informal HOA, with pay as you-go. Upstairs neighbor would like to begin monthly HOA dues of $440 to cover master building insurance, common electric, garbage, reserves.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Ice Maker;Freezer;Built-In Oven
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-07-08T18:46:27.000+0000
days_on_market__c, 1106
dom__c, 54
ffd_description_pb, This luxurious modern condo reimagined in 2017 offers open, dramatic spaces ideal for home living, relaxing and entertaining. This extraordinary bi-level residence features a grand room comprised of a living room with a gorgeous marble gas fireplace, dining room, and chef's kitchen in one seamless volume of space. A true chef's kitchen with its Thermador appliances, Uline wine fridge, custom cabinets, and stunning Vadara Calacutta Quartz island and counters. The sleeping quarters include 2 bedrooms on the upper floor and master bedroom with garden access below. The home features an exclusive sun-filled and serene backyard perfect for relaxation! Upscale finishes throughout the home include Carrera marble shower, porcelain tiles and white oak flooring. The home is perfectly located walking distance from the 24th Street corridor and includes 1 car garage parking and plentiful storage and closet space.
district__c, SF District 9
driveway_sidewalks__c, Paved Driveway,Shared Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
pba__floor__c, 0
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2022-01-25T15:26:12.000+0000
pba__latitude_pb__c, 37.750857
pba__latitude_property__c, 37.750857
listed_date__c, 2020-05-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alexander
pba__listing_agent_lastname__c, Lurie
listing_agent_mls_id__c, 810063
ffd_listingagentname, Alexander F Lurie
listing_agent_number__c, 1044526
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2249000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.407374
pba__lotsize_pb__c, 0
lower_level__c, Full Bath(s),Master Bedroom
mls_id__c, 500342
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
master_property__c, a0O1I000001ViYJUA0
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-07-08
original_price__c, 1998000
overall_days_on_market__c, 176
parking_access__c, Side by Side
parking_features__c, Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-08-31
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000SxxG0UAJ
room_type__c, Laundry
sale_date__c, 2020-09-30
sale_price__c, 2070000
selling_agent_mls_id__c, EB29394
selling_agent_number__c, 981074080
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Hampshire
subdist__c, The Mission
ffd_name, 1330 Hampshire Street, San Francisco, CA, 94110
transportation__c, 2 Blocks
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/365265-1.jpg
ListingId, a0E1I00000SxxG0UAJ