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, 748 Treat Avenue #2, San Francisco, CA, 94110
ffd_mls_id, 423726348
ffd_salesforce_id, a0E8W00000bbvBWUAY
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 3
address2__c, 748 Treat Avenue #2, San Francisco, CA, 94110
pba__address_pb__c, 748 Treat Avenue #2, San Francisco, CA, 94110
agent_only_remarks__c, Buyer to verify SQFT. Escrow with Mijael Schmidt at First American Title Co. Buyer to complete all inspections.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Built-In Gas Oven;Wine Refrigerator
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2015
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Frank A Nolan
pba__contingentdate__c, 2023-05-05
cooling__c, None
ffd_createddate, 2023-04-27T15:49:18.000+0000
days_on_market__c, 83
dom__c, 8
ffd_description_pb, Welcome to your dream home in the heart of the vibrant Mission neighborhood! This stunning three bedroom, condo boasts modern touches and a fantastic rear yard that will take your breath away. Step inside and be greeted by an open and airy living space that features high ceilings, sleek hardwood floors, and plenty of natural light. The living room is perfect for relaxing or entertaining, with ample space for your furniture. The adjacent dining area is perfect for hosting dinner parties, with room for a large table and access to the rear yard. The kitchen is a chef's dream, with top-of-the-line appliances, quartz countertops, and plenty of storage space. The three bedrooms are all spacious and offer plenty of privacy. The primary bedroom boasts a luxurious en-suite bathroom with a large shower, double vanity, and plenty of storage. The other two bedrooms share a modern bathroom with a bathtub and shower. But the true gem of this condo is the incredible rear yard. Step outside and be transported to your own private oasis, complete with lush landscaping, a spacious patio, and plenty of room for outdoor activities. Host a BBQ with friends, lounge in the sun, or simply enjoy the peaceful serenity of your own backyard.
748 Treat Avenue #2, San Francisco, CA, 94110 - Property Description
Welcome to your dream home in the heart of the vibrant Mission neighborhood! This stunning three bedroom, condo boasts modern touches and a fantastic rear yard that will take your breath away. Step inside and be greeted by an open and airy living space that features high ceilings, sleek hardwood floors, and plenty of natural light. The living room is perfect for relaxing or entertaining, with ample space for your furniture. The adjacent dining area is perfect for hosting dinner parties, with room for a large table and access to the rear yard. The kitchen is a chef's dream, with top-of-the-line appliances, quartz countertops, and plenty of storage space. The three bedrooms are all spacious and offer plenty of privacy. The primary bedroom boasts a luxurious en-suite bathroom with a large shower, double vanity, and plenty of storage. The other two bedrooms share a modern bathroom with a bathtub and shower. But the true gem of this condo is the incredible rear yard. Step outside and be transported to your own private oasis, complete with lush landscaping, a spacious patio, and plenty of room for outdoor activities. Host a BBQ with friends, lounge in the sun, or simply enjoy the peaceful serenity of your own backyard.
