meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218747' posts_per_page=4 post_type=property
bool(false)
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] => 2023-10-31 10:38:12
[post_modified_gmt] => 2023-10-31 17:38:12
[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
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Wall Furnace
ffd_lastmodifieddate, 2022-01-25T15:51:46.000+0000
pba__latitude_pb__c, 37.7753716
pba__latitude_property__c, 37.7753716
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2021-04-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alan
pba__listing_agent_lastname__c, Morcos
listing_agent_mls_id__c, 804261
ffd_listingagentname, Alan Morcos
listing_agent_number__c, 166013762
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 3350000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4333574
mls_id__c, 421545949
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tile;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-05-06
original_price__c, 3350000
overall_days_on_market__c, 178
parking_features__c, No Garage
pba__pendingdate__c, 2021-05-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1004.18
pba__propertytype__c, Single Family Residence
id, a0E1I00000UScRrUAL
roof__c, Tar/Gravel;Composition
sale_date__c, 2021-11-05
sale_price__c, 3600000
selling_agent_mls_id__c, 400638
selling_agent_number__c, 1021887
selling_co_agent_mls_id__c, 372883
selling_co_agent_number__c, 372883
selling_co_office_mls_id__c, COMP12PUI
selling_co_office_name__c, Compass
selling_co_office_number__c, 27690
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 3585
size__c, 3585
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Hayes
subdist__c, Alamo Square
ffd_name, 1027 Hayes Street, San Francisco, CA, 94117
view__c, City;San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1891
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530233235-1.jpg
ListingId, a0E1I00000UScRrUAL