meta_query='key:subdist__c;value:Bayview Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212297' 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-04-09 10:01:08
[post_modified_gmt] => 2024-04-09 17:01:08
[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
(
)
)
ffd_listing_title, 815 Meade Avenue, San Francisco, CA, 94124
ffd_mls_id, 498284
ffd_salesforce_id, a0E1I00000SliIYUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 2
address2__c, 815 Meade Avenue, San Francisco, CA, 94124
pba__address_pb__c, 815 Meade Avenue, San Francisco, CA, 94124
agent_only_remarks__c, Back on the market. Seller Reserves the right to accept or reject any offers. Offers reviewed as they come. Review all disclosures. Information provided is deemed reliable but not warranted by Agent, nor Broker.
appliances__c, Dishwasher;Insulated Water Heater;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Split Bath;Low-Flow Toilet(s);Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1998
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-05-18
ffd_createddate, 2020-05-17T10:46:34.000+0000
days_on_market__c, 1158
dom__c, 15
ffd_description_pb, Back on the Market. Fabulous Top Floor VIEW condo, with views of the Sutro tower, The tallest building in San Francisco-The Sales-force Tower,The Bay Bridge, and sweeping views of the City, all from the Living Room, Kitchen & back yard.Great Starter Home. This home, 815 Meade, is the top floor unit, of a two unit condo building. It consist of 2 bedrooms, 2 full baths, with inside laundry facilities.Fenced easy to maintain back yard and deck. 815 Meade Avenue,is conveniently located near freeway access 280 & 101, the T train/3rd Street Rail, near the warriors Stadium-the Chase Center, & the Giants AT&T Ball Park. With quick freeway access, you can be at San Francisco International Airport within 15 Minutes. This condo is the top unit in a 2 unit building. This home is A wonderful opportunity. Great Views, views, views
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Shared Driveway
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter
pba__floor__c, 0
pba__floortype_pb__c, Wood
hoa_dues__c, 0
hoa_fee_includes__c, Management,Homeowners Insurance
pba__hoafees__c, 0
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Hot Water;Central;Electric;Gas
ffd_lastmodifieddate, 2022-01-25T15:22:44.000+0000
pba__latitude_pb__c, 37.717085
pba__latitude_property__c, 37.717085
laundry_appliances__c, 220 Volt Wiring,Washer/Dryer,In Laundry Room
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-05-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, McGary
listing_agent_mls_id__c, 900297
ffd_listingagentname, John H McGary
listing_agent_number__c, 900297
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, RESE
listing_office_name__c, J. M. Real Estate Services
listing_office_number__c, 1831
pba__listingprice_pb__c, 799000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.396558
pba__lotsize_pb__c, 0
mls_id__c, 498284
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000004VXj8UAG
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-05-17
original_price__c, 799000
overall_days_on_market__c, 44
parking_access__c, Independent
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-06-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 548.46
pba__propertytype__c, Condominium
id, a0E1I00000SliIYUAZ
room_type__c, Laundry
sale_date__c, 2020-06-03
sale_price__c, 730000
selling_agent_mls_id__c, 811041
selling_agent_name__c, Winnie Lai
selling_agent_number__c, 1049417
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 1331
size__c, 1331
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Meade
subdist__c, Bayview Heights
ffd_name, 815 Meade Avenue, San Francisco, CA, 94124
transportation__c, 2 Blocks
view__c, Panoramic;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Twin Peaks
website_property_type__c, Condominium
window_features__c, Weather Stripped;Caulked/Sealed
pba__yearbuilt_pb__c, 1998
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363261-1.jpg
ListingId, a0E1I00000SliIYUAZ