meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='421295' 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] => 2024-11-07 09:28:38
[post_modified_gmt] => 2024-11-07 17:28:38
[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
(
)
)
_yoast_indexnow_last_ping, 1736914678
ffd_listing_title, 1228 Grove Street #2, San Francisco, CA, 94117
ffd_mls_id, 424059277
ffd_salesforce_id, a0EUd000003fw1WMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 6
address2__c, 1228 Grove Street #2, San Francisco, CA, 94117
pba__address_pb__c, 1228 Grove Street #2, San Francisco, CA, 94117
agent_only_remarks__c, Pre-escrow has been opened with WFG, Mary Anne Bunnell. Phone: (415) 753-3003 Email: MBunnell@wfgtitle.com
bath_features__c, Split Bath
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1917
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-11-22T18:47:57.000+0000
days_on_market__c, 106
dom__c, 74
ffd_description_pb, Situated in the heart of one of San Francisco's most coveted neighborhoods, this enchanting Edwardian condominium in Alamo Square offers a blend of classic charm and modern convenience. The entire unit is light and airy, creating a warm and inviting atmosphere throughout. The home features two serene bedrooms, including a primary suite that boasts a huge cedar-lined closet and windows looking out to verdant trees, offering both ample storage and a soothing view. The beautifully appointed kitchen is a chef's delight, equipped with stainless steel appliances, sleek quartz countertops, ample cabinet space, and generous counter space perfect for preparing gourmet meals. The expansive living room, with windows framing lush greenery, provides a tranquil retreat to unwind. Additional features include new windows that enhance the home's brightness and an in-unit washer and dryer for ultimate convenience. Set on the quieter side of the building, this residence includes abundant closet space, a spacious storage room, and access to a peaceful shared garden. Located in a charming six-unit boutique building with low HOA fees, this home offers a unique sense of community and affordability. Step outside to discover a culinary paradise, with an array of nearby restaurants, cafes, and bars.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 350
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Ocean Beach Management, LLC
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2025-01-15T03:47:53.000+0000
pba__latitude_pb__c, 37.7763068
pba__latitude_property__c, 37.7763068
laundry_features__c, In Kitchen;Washer Included;Dryer Included
listed_date__c, 2024-08-22
pba__listing_agent_email__c, michelle.pender@evrealestate.com
pba__listing_agent_firstname__c, Michelle
pba__listing_agent_lastname__c, Pender
listing_agent_mls_id__c, 808357
ffd_listingagentname, Michelle K Pender
listing_agent_number__c, 1033936
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SANF4
listing_office_name__c, Engel & Voelkers San Francisco
listing_office_number__c, 28140
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4369097
mls_id__c, 424059277
master_property__c, a0O1I000001Vij3UAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-09-30
open_house_end__c, 2025-01-19T16:00:00.000+0000
open_house_start__c, 2025-01-19T14:00:00.000+0000
original_price__c, 1191000
overall_days_on_market__c, -82087
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1148.96
pba__propertytype__c, Condominium
ListingId, a0EUd000003fw1WMAQ
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 866
size__c, 866
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Grove
subdist__c, Alamo Square
ffd_name, 1228 Grove Street #2, San Francisco, CA, 94117
view__c, Garden/Greenbelt
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1917
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530843095-1.jpg