Array
(
[ID] => 70657
[post_author] => 4
[post_date] => 2018-11-30 20:30:31
[post_date_gmt] => 2018-11-30 20:30:31
[post_content] => Proximity to parks, room to roam, and the Pacific Ocean at your front door. Downtown is a quick (and probably crowded) L-Taraval ride away, and car commuters can hop on 19th Avenue to head south. Like its northern twin the Sunset, there’s more fog than on the east side of town, but that keeps things cool and comfy.
[post_title] => Parkside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => parkside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-06-04 10:53:39
[post_modified_gmt] => 2024-06-04 17:53:39
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70657
[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, 2551 28th Avenue, San Francisco, CA, 94116
ffd_mls_id, 423729061
ffd_salesforce_id, a0E8W00000bbDnjUAE
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 2551 28th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2551 28th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Photos include staging, but staging has been removed. Help your clients earn a piece of SF History. This is one of the first and original Parkside Spec Cottages from 1906. Please contact listing agent Melanie Leung at 415.680.8286 or [email protected]. Pre-escrow 3542200669 opened with Kim Diep with Chicago Title Company. Offers being accepted as they come. Disclosures available at https://app.disclosures.io/link/2551-28th-Avenue-alr6vgcq
appliances__c, Dishwasher;Gas Water Heater;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Gas Plumbed
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Tile;Low-Flow Shower(s);Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1906
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-06-26
ffd_createddate, 2023-04-13T19:48:45.000+0000
days_on_market__c, 137
dom__c, 89
ffd_description_pb, This fully detached VACANT home is a historical gem as one of the Parkside cottages built in SF. This 3BR/2BA retreat pairs contemporary elegance with modern comfort for an elevated living experience. Step inside the welcoming foyer and discover an abundance of natural light complemented by an open floor plan boasting a living/dining room combination perfect for relaxing and entertaining guests. The kitchen is a perfect blend of functionality for you to explore your culinary curiosities. Enjoy morning coffee or a quick bite to eat in the breakfast nook while basking in the warm southern exposure. Main level has 2BR/1BA. Downstairs is complemented with a family room, bedroom, laundry room and bathroom with direct access to a spacious flat rear backyard accented with a beautiful mature tree. Located in a prime location, this home is walking distance to Parkside Square w/ athletic fields and playgrounds, the Stern Grove Rec area, minutes to excellent dining, surrounded by great schools and convenient transportation options along Taraval Street. With solar panels, updated electrical, furnace & water heater. A 20 year roof warranty transfer included-This is an opportunity not to be missed!
2551 28th Avenue, San Francisco, CA, 94116 - Property Description
This fully detached VACANT home is a historical gem as one of the Parkside cottages built in SF. This 3BR/2BA retreat pairs contemporary elegance with modern comfort for an elevated living experience. Step inside the welcoming foyer and discover an abundance of natural light complemented by an open floor plan boasting a living/dining room combination perfect for relaxing and entertaining guests. The kitchen is a perfect blend of functionality for you to explore your culinary curiosities. Enjoy morning coffee or a quick bite to eat in the breakfast nook while basking in the warm southern exposure. Main level has 2BR/1BA. Downstairs is complemented with a family room, bedroom, laundry room and bathroom with direct access to a spacious flat rear backyard accented with a beautiful mature tree. Located in a prime location, this home is walking distance to Parkside Square w/ athletic fields and playgrounds, the Stern Grove Rec area, minutes to excellent dining, surrounded by great schools and convenient transportation options along Taraval Street. With solar panels, updated electrical, furnace & water heater. A 20 year roof warranty transfer included-This is an opportunity not to be missed!
