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, 154 Julian Avenue, San Francisco, CA, 94103
ffd_mls_id, 501789
ffd_salesforce_id, a0E1I00000Sy2nNUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 154 Julian Avenue, San Francisco, CA, 94103
pba__address_pb__c, 154 Julian Avenue, San Francisco, CA, 94103
agent_only_remarks__c, More info including virtual tour at www.AtHomeInTheMission.com Showings by appointment. Schedule with calendly at https://calendly.com/domicile/154julian and then send signed PEAD form to [email protected] for access info. Cottage at rear is in process of being legalized as an ADU. The one-car garage is accessed at rear by alley (Caledonia). Escrow with Gerrie Brindley at Chicago Title. For questions or more info call, email or text Shane (415.225.5990) or Julie (415.730.6387)- [email protected]
appliances__c, Dishwasher;Gas Range;Refrigerator
architectural_style__c, Edwardian
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1911
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Shane R Ray
pba__contingentdate__c, 2020-08-06
ffd_createddate, 2020-07-17T00:45:55.000+0000
days_on_market__c, 1098
dom__c, 32
ffd_description_pb, This exquisite 4BR/2.5BA Edwardian home w/ a perfect cottage retreat at the rear offers the rare elegance & grandeur of an Edwardian but modern updates for today's living. 2 full scale living rms open to a huge dining rm & classically appointed kitchen; an ideal configuration for entertaining on a large scale. Past the public spaces are 2 bdrms, a full bath,1/2 bath & laundry rm. The top floor is comprised of an enormous master suite w/ 2 sitting areas & a spa-like bath. Another bdrm on this level could be a nursery, office or library. At the rear of the property sits the perfect cottage w/ a full bath & kitchenette; an incredibly picturesque place to host family or to use as an office, gym, rental or extension of the outdoor space.The beautifully landscaped courtyard sits between the main house & cottage, creating a tranquil refuge in the heart of SF. A 1-car garage is accessed from the alley behind. Steps from the pulse of the mission including restaurants, bars, shops & transit.
154 Julian Avenue, San Francisco, CA, 94103 - Property Description
This exquisite 4BR/2.5BA Edwardian home w/ a perfect cottage retreat at the rear offers the rare elegance & grandeur of an Edwardian but modern updates for today's living. 2 full scale living rms open to a huge dining rm & classically appointed kitchen; an ideal configuration for entertaining on a large scale. Past the public spaces are 2 bdrms, a full bath,1/2 bath & laundry rm. The top floor is comprised of an enormous master suite w/ 2 sitting areas & a spa-like bath. Another bdrm on this level could be a nursery, office or library. At the rear of the property sits the perfect cottage w/ a full bath & kitchenette; an incredibly picturesque place to host family or to use as an office, gym, rental or extension of the outdoor space.The beautifully landscaped courtyard sits between the main house & cottage, creating a tranquil refuge in the heart of SF. A 1-car garage is accessed from the alley behind. Steps from the pulse of the mission including restaurants, bars, shops & transit.
