meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='423492' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15110
[post_author] => 4
[post_date] => 2018-10-31 19:36:27
[post_date_gmt] => 2018-10-31 19:36:27
[post_content] => Not quite the Mission, not quite the Castro, Mission Dolores is a bustling, centrally located neighborhood with some iconic San Francisco attractions. The crown jewels of the neighborhood are Dolores Park and Mission Dolores, the oldest Spanish Mission church in San Francisco. Sun worshippers flock to Dolores Park on warm and cool days alike, and the church welcomes worshippers for regular services.
[post_title] => Mission Dolores
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-dolores
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-15 12:13:19
[post_modified_gmt] => 2024-11-15 20:13:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15110
[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, 1738412309
ffd_listing_title, 49 Albion Street #A, San Francisco, CA, 94103
ffd_mls_id, 425005689
ffd_salesforce_id, a0EUd0000048D2gMAE
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 4
pba__address_pb__c, 49 Albion Street #A, San Francisco, CA, 94103
address2__c, 49 Albion Street #A, San Francisco, CA, 94103
agent_only_remarks__c, Please call Sarah for showing info @628.629.4405. First opens sat/sun 1/25+26. TIC. 27% interest. Property at the back of the lot @49-51 Albion, sep gate/walkway on the left. Disclosures available 1/27.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Tankless Water Heater;Built-In Gas Oven;Built-In Refrigerator;Gas Plumbed
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1908
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sarah Tulin
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2025-01-24T20:47:08.000+0000
days_on_market__c, 8
dom__c, 8
ffd_description_pb, Hidden away on the street that birthed our city, a one-of-a-kind property awaits. This fully detached, house-like, 3-level cottage masterfully blends vintage charm w/ modern sophistication. Nestled in the heart of one of SF's most vibrant neighborhoods, it offers a rare combination of energy and tranquilityyour own private oasis in the city. Truly, the best of both worlds. This property is all about character: rustic wood floors conceal updated radiant heating, a serene living room, and a funky stainless kitchen that's perfect for casual dinners or pre-Valencia cocktails. Enjoy a cozy dining nook, a moody bath, and front porch w/ in-unit laundry. Upstairs, two peaceful sunlight bedrooms, while the lower level is a versatile suite that can flex as a luxe primary retreat, professional recording/creative studio, or a hangout-ready media room, complete w/ its own bath. Every inch has been dialed in: updated systems, on-demand hot water, modern lighting, and a floating matt-slab foundation built to laugh off earthquakes. Located on a tree-lined street, you're steps from Valencia's hottest spotsthink craft cocktails, indie coffee shops, and Michelin-star eatsplus effortless access to all transportation. Come see what life could look like at 49A Albionwhere vintage meets vibe.
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Management,Other
pba__hoafees__c, 286
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 49A-49-51A-51 Albion St TIC
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2025-02-01T11:46:37.000+0000
pba__latitude_pb__c, 37.7657006
pba__latitude_property__c, 37.7657006
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2025-01-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Baxter
pba__listing_agent_lastname__c, Smith
listing_agent_mls_id__c, 810357
ffd_listingagentname, Baxter Smith
listing_agent_number__c, 1045827
listing_co_agent_mls_id__c, 818399
listing_co_agent_number__c, 1077149
listing_co_office_mls_id__c, CITYRE
listing_co_office_name__c, City Real Estate
listing_co_office_number__c, 27425
listing_office_mls_id__c, CITYRE
listing_office_name__c, City Real Estate
listing_office_number__c, 27425
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4228905
lower_level__c, Family Room,Full Bath(s),Retreat,Street Entrance
mls_id__c, 425005689
main_level__c, Full Bath(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2025-01-24
open_house_end__c, 2025-02-02T16:00:00.000+0000
open_house_start__c, 2025-02-02T14:00:00.000+0000
original_price__c, 995000
overall_days_on_market__c, -82203
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, 748.12
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd0000048D2gMAE
room_type__c, Bonus Room;Kitchen;Living Room;Game Room;Family Room;Possible Guest;Media Room
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
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, 1330
size__c, 1330
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Albion
subdist__c, Mission Dolores
ffd_name, 49 Albion Street #A, San Francisco, CA, 94103
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94103
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530935700-1.jpg