meta_query='key:subdist__c;value:Alamo Square|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209848' 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-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, 509 Pierce Street #4, San Francisco, CA, 94117
ffd_mls_id, 493998
ffd_salesforce_id, a0E1I00000Q3NL5UAN
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 4
address2__c, 509 Pierce Street #4, San Francisco, CA, 94117
pba__address_pb__c, 509 Pierce Street #4, San Francisco, CA, 94117
agent_only_remarks__c, Offers, if any, due Monday 2/3 at 1PM. Parking is tandem and must be small to compact size and automatic transmission. For disclosures please email Lucas at [email protected] or text at 415-264-5980. Please submit offers on SFAR Purchase Agreement. Escrow is open with Gerrie Brindley at Chicago Title on Market St.
appliances__c, Dishwasher;Gas Range;Refrigerator;Hood Over Range;ENERGY STAR Qualified Appliances;Built-In Oven;Self/Cont Clean Oven
architectural_style__c, Marina
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Marble
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-01-23T11:47:15.000+0000
days_on_market__c, 1273
dom__c, 12
ffd_description_pb, This bright and airy top floor condo features 1 bedroom, 1 bathroom, an office nook, 1 car tandem parking, designated storage, and a shared yard. The kitchen was recently updated with quartz countertops, new luxury vinyl flooring, and new stainless steel appliances and sink. The large bedroom has plenty of closet space and two sets of french doors making it a highly functional space. Across the hallway is an apothecary-inspired bathroom recently updated with new marble flooring, vanity, and lighting. Further, down the hallway is a very large storage closet followed by the open concept living and dining room featuring Marina style bay windows that let in tons of natural light. Off the living space is an additional office nook that could serve many different functions. With a walk score of 98, a transit score of 94, and a bike score of 77, this location is extremely central to everything. Nopa, Hayes Valley, Duboce Triangle, and the Lower Haight are all within a short walk.
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Marble;Vinyl;Wood
hoa_dues__c, 350
hoa_fee_includes__c, Maintenance Exterior,Trash,Maintenance Grounds,Homeowners Insurance,Water
pba__hoafees__c, 350
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 509 Pierce HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Electric;Wall Furnace
ffd_lastmodifieddate, 2022-01-12T15:26:44.000+0000
pba__latitude_pb__c, 37.77466
pba__latitude_property__c, 37.77466
laundry_appliances__c, Washer/Dryer,In Garage
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-01-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lucas
pba__listing_agent_lastname__c, Sorah
listing_agent_mls_id__c, 810513
ffd_listingagentname, Lucas Sorah
listing_agent_number__c, 1046592
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 899000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.43464
pba__lotsize_pb__c, 0
mls_id__c, 493998
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000001ViB0UAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-01-23
original_price__c, 899000
overall_days_on_market__c, 68
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Size Limited,Tandem Garage,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-02-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1284.39
pba__propertytype__c, Condominium
id, a0E1I00000Q3NL5UAN
roof__c, Tar/Gravel
room_type__c, Office;Den
sale_date__c, 2020-02-24
sale_price__c, 1111000
selling_agent_mls_id__c, 810364
selling_agent_name__c, Deborah Lynn Rutledge
selling_agent_number__c, 1045860
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 865
size__c, 865
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Pierce
subdist__c, Alamo Square
ffd_name, 509 Pierce Street #4, San Francisco, CA, 94117
transportation__c, 1 Block
unit_number__c, 4
view__c, Park;Partial
website_property_type__c, Condominium
window_features__c, Weather Stripped
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/359457-1.jpg
ListingId, a0E1I00000Q3NL5UAN