Array
(
[ID] => 15731
[post_author] => 4
[post_date] => 2018-11-02 19:54:56
[post_date_gmt] => 2018-11-02 19:54:56
[post_content] => The site of perhaps the most photographed vista in San Francisco, Alamo Square is home to the world-famous Painted Ladies. The row of iconic Victorian homes, with the city skyline as the backdrop, provides a picture-perfect postcard view of San Francisco.
Equally famous in movies is Alamo Square Park; on a hilltop overlooking the Painted Ladies, locals and tourists frequent the green space, playgrounds, walking trails, dog park, and tennis courts.
Architecture in Alamo Square is predominately Victorian and has the distinct honor of being the location of numerous homes exceeding 10,000 square feet of living space.
[post_title] => Alamo Square
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => alamo-square
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 08:50:23
[post_modified_gmt] => 2024-04-09 15:50:23
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15731
[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, 1027 Hayes Street, San Francisco, CA, 94117
ffd_mls_id, 421545949
ffd_salesforce_id, a0E1I00000UScRrUAL
num_of_fireplaces__c, 3
num_of_rooms__c, 18
of_units__c, 0
address2__c, 1027 Hayes Street, San Francisco, CA, 94117
pba__address_pb__c, 1027 Hayes Street, San Francisco, CA, 94117
agent_only_remarks__c, Excellent floor plan for family compound, multi-generational living, or could use as a 4 Bedroom Home with 2 separate apartments to generate rental income. Main residence is approximately 2,705 square feet with additional 440 square foot apartment that is attached. 1 Bedroom apartment on lower level is approximately 440 square feet. All units are owner occupied. COPA requirements have been satisfied. Showing by appointment only, please schedule through Calendly link: https://calendly.com/alanmorcosrealestate/1027-hayes
appliances__c, Dishwasher;Tankless Water Heater;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1891
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-07T02:48:07.000+0000
days_on_market__c, 804
dom__c, 4
ffd_description_pb, Constructed in 1891 & originally commissioned by John Wilton, this Grand Victorian overlooking Alamo Square & Post Card Row has been featured on HGTV's Dream Drives! The Main Level features a Foyer, Grand Living Room w/Fireplace & Views of Alamo Square, Library, Large Dining Room w/Fireplace, Study/Office & Eat-In Kitchen. Upstairs the Primary Bedroom has Views of Alamo Square, Fireplace, an En-Suite Remodeled Bath & 2 Generous Closets. There are 3 more Spacious Bedrooms (one with a Sink), a Remodeled Bath & Laundry Closet. In the rear of the house there is a 1 Bedroom Apartment on the Main Level and an Attached Studio Apartment on the second floor with a Private Deck. Enjoy peaceful afternoons in the Wonderfully Landscaped South Facing Garden. This Well-Preserved Home has Exquisite Ceiling Medallions, Period Wallpaper, Vintage Chandeliers & Doorknobs & Stained Glass Skylight. Perfect for a Family Compound, Multi-Generational Living or Income Generating Property!
district__c, SF District 6
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Master Bedroom;Dining Room
1027 Hayes Street, San Francisco, CA, 94117 - Property Description
Constructed in 1891 & originally commissioned by John Wilton, this Grand Victorian overlooking Alamo Square & Post Card Row has been featured on HGTV's Dream Drives! The Main Level features a Foyer, Grand Living Room w/Fireplace & Views of Alamo Square, Library, Large Dining Room w/Fireplace, Study/Office & Eat-In Kitchen. Upstairs the Primary Bedroom has Views of Alamo Square, Fireplace, an En-Suite Remodeled Bath & 2 Generous Closets. There are 3 more Spacious Bedrooms (one with a Sink), a Remodeled Bath & Laundry Closet. In the rear of the house there is a 1 Bedroom Apartment on the Main Level and an Attached Studio Apartment on the second floor with a Private Deck. Enjoy peaceful afternoons in the Wonderfully Landscaped South Facing Garden. This Well-Preserved Home has Exquisite Ceiling Medallions, Period Wallpaper, Vintage Chandeliers & Doorknobs & Stained Glass Skylight. Perfect for a Family Compound, Multi-Generational Living or Income Generating Property!
