meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235532' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15729
[post_author] => 4
[post_date] => 2018-11-02 19:54:53
[post_date_gmt] => 2018-11-02 19:54:53
[post_content] => From freeway-bisected loser to urban renaissance pedestrian paradise winner. Sunny. Central. Flat. Where Victorians make friends with modern condos. Great shops, boutiques, and restaurants served by great transit. A San Francisco success story.
[post_title] => Hayes Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => hayes-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:31:42
[post_modified_gmt] => 2024-04-09 18:31:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15729
[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, 51 Germania Street, San Francisco, CA, 94117
ffd_mls_id, 421611511
ffd_salesforce_id, a0E8W00000V2wyUUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 2
address2__c, 51 Germania Street, San Francisco, CA, 94117
pba__address_pb__c, 51 Germania Street, San Francisco, CA, 94117
agent_only_remarks__c, For more information, disclosures, or showing requests, please contact Svetlana Shkolnikov (415) 680-5139. Pre-sale escrow opened with Yvette Gonzalez at ORTC San Francisco, #0224057942. All buyers to use the most current 7-page SFAR contract. Prospective purchasers are advised to independently verify accuracy and to review any disclosure information before submitting offers.
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Oven;Free Standing Electric Range
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1996
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-01-13T11:50:58.000+0000
days_on_market__c, 552
dom__c, 70
ffd_description_pb, Price Adjustment! Luxury townhome spanning three levels in the sought after Hayes Valley neighborhood. Flooded with natural light, this home comes with 2 bedrooms and 1.5 baths. Off the entry on the ground level, you'll find a powder room and direct access to a private outdoor space. The main level includes a kitchen with custom cabinetry, quartz counters and stainless appliances and a sunken living room with a gas fireplace. On the top are two bedrooms with closet organizers, stackable washer/dryer and full bath with walk-in shower. This home features city views from the rear bedroom, hardwood floors thought out and comes with a 1-car garage. Located at the intersection of the Lower Haight and Duboce Triangle, this trendy enclave is near Duboce Park and is surrounded by eateries and an abundance of public transportation options.
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Homeowners Insurance,Insurance on Structure
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2022-04-28T01:47:54.000+0000
pba__latitude_pb__c, 37.770689
pba__latitude_property__c, 37.770689
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2021-11-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Svetlana
pba__listing_agent_lastname__c, Shkolnikov
listing_agent_mls_id__c, 813225
ffd_listingagentname, Svetlana Shkolnikov
listing_agent_number__c, 1060315
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, RADIUS
listing_office_name__c, Radius Agent Realty
listing_office_number__c, 28554
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.429364
lower_level__c, Garage,Partial Bath(s)
mls_id__c, 421611511
main_level__c, Kitchen;Living Room;Dining Room
master_property__c, a0O1I000008ouSrUAI
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-01-13
original_price__c, 1650000
overall_days_on_market__c, -81096
parking_access__c, Independent
parking_features__c, Assigned,Attached,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Enclosed Patio;Uncovered Patio
pba__pendingdate__c, 2022-03-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-04-27T10:06:24.000+0000
price_per_square_foot__c, 1422.22
pba__propertytype__c, Condominium
id, a0E8W00000V2wyUUAR
room_type__c, Kitchen
sale_date__c, 2022-04-27
sale_price__c, 1600000
selling_agent_mls_id__c, MLSL5061692
selling_agent_number__c, 981215825
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Giant Realty Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 1125
size__c, 1125
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Germania
subdist__c, Hayes Valley
ffd_name, 51 Germania Street, San Francisco, CA, 94117
view__c, City Lights;San Francisco;Mountains
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1996
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530358916-1.jpg
ListingId, a0E8W00000V2wyUUAR