meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376965' 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
(
)
)
_yoast_indexnow_last_ping, 1721300129
ffd_listing_title, 1045 York Street #B, San Francisco, CA, 94110
ffd_mls_id, 424027744
ffd_salesforce_id, a0EUd000001u9fzMAA
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 3
address2__c, 1045 York Street #B, San Francisco, CA, 94110
pba__address_pb__c, 1045 York Street #B, San Francisco, CA, 94110
agent_only_remarks__c, Text or call Rose for combo code. Seller prefers to keep escrow with Title Forward, they have worked hard in preparing all documents. $280 monthly HOA includes water + insurance and is managed by the owners. DISCLOSURES LINK: https://app.disclosures.io/link/1045-York-Street-B-bhewt6q2
appliances__c, Dishwasher
architectural_style__c, Craftsman;Cottage
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1896
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-05-02T15:46:22.000+0000
days_on_market__c, 77
dom__c, 77
ffd_description_pb, Must see! Fully detached two story condo with low HOA dues. Shows like a single family home. Welcome to the Inner Mission's hidden treasure on York Street! This is not your average condo! This historic carriage house, built in 1896, stands proudly as a fully detached residence, poised as single-family home. Seamlessly blending period charm with modern conveniences, this residence boasts two floors of inviting living space. Step inside to discover an open floor plan on the first floor, connecting the living room, dining area, and kitchen. Completing this level is a convenient half bath, radiant heated concrete floors, complemented by a staircase leading to the second floor. Ascending to the upper level, you'll find a versatile loft space, complete with a laundry area, office nook, and built in storage hutch. In addition, a cozy bedroom, and a sun drenched primary bedroom await, along with a spa-like bathroom. High ceilings throughout. Outside the front door you will find a peaceful courtyard perfect to relax, have a drink, or read a book. Additional storage in garage. Experience the timeless craftsmanship and functional design of this unique home - a true gem tucked away thats nestled within the heart of the Mission.
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
pba__floortype_pb__c, Concrete;Wood
hoa_fee_includes__c, Insurance,Water
pba__hoafees__c, 280
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1045 York St
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant;Wall Furnace
ffd_lastmodifieddate, 2024-07-18T10:50:47.000+0000
pba__latitude_pb__c, 37.7553317
pba__latitude_property__c, 37.7553317
laundry_features__c, Inside Area;Washer Included;Dryer Included
listed_date__c, 2024-04-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rosemarie
pba__listing_agent_lastname__c, Hayes
listing_agent_mls_id__c, 811266
ffd_listingagentname, Rose Hayes
listing_agent_number__c, 1050716
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REDF
listing_office_name__c, Redfin
listing_office_number__c, 64045
pba__listingprice_pb__c, 1050000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=ntGG1rsMTgb&brand=0
pba__longitude_pb__c, -122.4082448
mls_id__c, 424027744
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_property__c, a0OUd000006ig3WMAQ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-05-02
open_house_end__c, 2024-07-21T16:00:00.000+0000
open_house_start__c, 2024-07-21T13:00:00.000+0000
original_price__c, 1150000
overall_days_on_market__c, -81936
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1000
pba__propertytype__c, Condominium
ListingId, a0EUd000001u9fzMAA
room_type__c, Kitchen;Loft;Living Room;Dining Room;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1050
size__c, 1050
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, York
subdist__c, The Mission
ffd_name, 1045 York Street #B, San Francisco, CA, 94110
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1896
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530767776-1.jpg
