meta_query='key:subdist__c;value:Bayview Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376542' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70678
[post_author] => 4
[post_date] => 2018-11-30 20:31:14
[post_date_gmt] => 2018-11-30 20:31:14
[post_content] => You probably didn't know this neighborhood was a thing -- it's a tiny triangle of land bounded by the 101 to the west, Bayview Park to the east, and the industrial land of the Bayview to the north. It's similar in style to the Bayview, except none of the streets make any sense!
[post_title] => Bayview Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bayview-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-01 10:46:10
[post_modified_gmt] => 2024-11-01 17:46:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70678
[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, 1714042649
ffd_listing_title, 1001 Jamestown Avenue, San Francisco, CA, 94124
ffd_mls_id, 423920567
ffd_salesforce_id, a0E8W00000dxXnLUAU
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1001 Jamestown Avenue, San Francisco, CA, 94124
pba__address_pb__c, 1001 Jamestown Avenue, San Francisco, CA, 94124
agent_only_remarks__c, All offers must be submitted by the Buyer's agent via the RES.NET Agent Portal. If your offer is accepted, you agree to be responsible for an offer submission technology fee of $150.00. The fee will be collected and disbursed by the settlement agent and disbursed at the closing and settlement of the transaction. To submit your buyer's offer, simply click the link below. If you already have a RES.NET Agent account, you will be prompted to log in. If not, you will be prompted to create an account. To begin, click or paste this link into your web browser: https://agent.res.net/Offers.aspx?-1790137. Buyer must assume open permit|violations issues and sign a Hold Harmless (Associated Docs) prior to touring. Room count and living sqft differs from county records. Former owner remodeled the home without the benefit of permits. Buyer to conduct all investigations|inspections to their satisfaction. Buyer acknowledges and agrees that Buyer is accepting the Property 'As Is,' without any warranties, representations or guarantees, either expressed or implied, of any kind, nature or type whatsoever from or on behalf of the Seller. Please call/text Anh @650.380.6364, for any questions.
appliances__c, Dishwasher;Built-In Gas Oven;Free Standing Refrigerator;Gas Cook Top
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1930
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-03-15
ffd_createddate, 2023-11-03T10:48:42.000+0000
days_on_market__c, 175
dom__c, 139
ffd_description_pb, So much potential on this DOUBLE LOT in the sunny, vibrant neighborhood of Bayview Heights! Situated atop a hill, this FULLY DETACHED home offers privacy in your own peaceful and secluded atmosphere. For those who appreciate outdoor dining and entertainment, imagine stepping onto a stupendous porch that takes your breath away. As you enter the home, you'll find a spacious living room with large windows that allow an abundance of natural light. The open floorplan seamlessly connects the living room to the dining area & kitchen, creating a sense of unity as you enjoy quality time with loved ones. The kitchen is modern and well-equipped with sleek appliances and ample storage space. This charming home boasts three bedrooms, each offering a cozy and relaxing atmosphere. The master bedroom includes a walk-in closet and direct access to the rear patio. One of the highlights of this home is its backyard, which is perfect for outdoor activities and relaxation. It offers a tranquil oasis with a low maintenance turf and top deck for lounging while soaking in the stunning views of the bay. Location benefits from its proximity to various amenities, including parks, schools, shops, and restaurants. Situated near Muni Metro, close to Caltrain and easy freeway access to other parts of the city
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Carpet;Tile;Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-04-25T10:47:01.000+0000
pba__latitude_pb__c, 37.7184095
pba__latitude_property__c, 37.7184095
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-11-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Anh
pba__listing_agent_lastname__c, Pham
listing_agent_mls_id__c, 807249
ffd_listingagentname, Anh H Pham
listing_agent_number__c, 1012152
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SKYGR
listing_office_name__c, SkyGroup Realty Inc.
listing_office_number__c, 25039
pba__listingprice_pb__c, 764900
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3938732
mls_id__c, 423920567
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-11-02
original_price__c, 934900
overall_days_on_market__c, -81754
parking_access__c, Independent
parking_features__c, Detached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-03-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dxXnLUAU
room_type__c, Laundry;Primary Bathroom
sale_date__c, 2024-04-22
sale_price__c, 764900
selling_agent_mls_id__c, EB147304
selling_agent_number__c, 981309852
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Jamestown
subdist__c, Bayview Heights
ffd_name, 1001 Jamestown Avenue, San Francisco, CA, 94124
view__c, City;City Lights;Water;Downtown;San Francisco
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1930
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530700395-1.jpg