meta_query='key:subdist__c;value:Visitacion Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='322662' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70688
[post_author] => 4
[post_date] => 2018-11-30 20:41:51
[post_date_gmt] => 2018-11-30 20:41:51
[post_content] => Found on the far south side of San Francisco, Visitacion Valley slopes steeply down. From the heights of the valley in its northeast corner, ramble down to bay level where San Francisco ends and Daly City begins. Homes in the northeast heights offer some soaring southern views.
[post_title] => Visitacion Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => visitacion-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 11:09:58
[post_modified_gmt] => 2024-04-11 18:09:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70688
[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, 1705 Geneva Avenue, San Francisco, CA, 94134
ffd_mls_id, 422704548
ffd_salesforce_id, a0E8W00000ZM8uLUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1705 Geneva Avenue, San Francisco, CA, 94134
pba__address_pb__c, 1705 Geneva Avenue, San Francisco, CA, 94134
agent_only_remarks__c, Vacant and easy to show by combo lockbox at front gate. Please call LA for the code. Pre-opened escrow with ORTC. E#0216037210. Disclosures will be provided upon request by email.Please submit offer in SFAR Purchase agreement with proof of funds, pre-approval letter,and disclosure cover pages. Please give sellers 48-72 hours to respond offer. Sellers reserve the right to accept, counter and reject any offer. Disclosure link: https://app.disclosures.io/link/1705-Geneva-Avenue-0524xzit
appliances__c, Dishwasher;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1946
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-11-14
ffd_createddate, 2022-10-29T00:47:04.000+0000
days_on_market__c, 264
dom__c, 45
ffd_description_pb, Conveniently located in the Crocker Amazon foothills, this gorgeous home offers tons of upgrades. Upstairs, a tastefully updated kitchen opens into a sun-drenched living room, which leads to 2 bedrooms and a fully renovated bathroom with skylight. Downstairs, the permitted game/family room and full bathroom provide extra living space and separation. Hardwood floors, recessed lighting, and dual pane windows throughout. Attached garage easily accommodates a large minivan plus storage needs. Additional upgrades include: newer furnace, tankless water heater, updated sump pump, low maintenance backyard with concrete retaining wall. Steps away from parks, plus easy access to MUNI/BART, freeways (101/280) and biotech office hubs.
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-07-13T18:03:19.000+0000
pba__latitude_pb__c, 37.7113068
pba__latitude_property__c, 37.7113068
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2022-10-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jim
pba__listing_agent_lastname__c, Zeng
listing_agent_mls_id__c, 370886
ffd_listingagentname, Jim Z Zeng
listing_agent_number__c, 370886
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COLD03
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 875
pba__listingprice_pb__c, 895000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=9uDc4BTBABi&brand=0
pba__longitude_pb__c, -122.4265638
lower_level__c, Family Room,Full Bath(s),Garage
mls_id__c, 422704548
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-10-28
original_price__c, 895000
overall_days_on_market__c, -81384
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-12-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 779.85
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZM8uLUAT
room_type__c, Kitchen;Living Room;Game Room;Family Room;Possible Guest
sale_date__c, 2023-01-11
sale_price__c, 960000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, MLSL5080610
selling_agent_number__c, 981342672
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Kinetic Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1231
size__c, 1231
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Geneva
subdist__c, Visitacion Valley
ffd_name, 1705 Geneva Avenue, San Francisco, CA, 94134
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Bay Window(s)
pba__yearbuilt_pb__c, 1946
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530548747-1.jpg