meta_query='key:subdist__c;value:Inner Richmond|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='385175' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12162
[post_author] => 4
[post_date] => 2018-10-29 01:21:18
[post_date_gmt] => 2018-10-29 01:21:18
[post_content] => Barely west of Laurel Village and Jordan Park. Very east of Ocean Beach. It's not a transitional neighborhood, it's the Inner Richmond. Delightful shops on Clement Street and a surprisingly central location. But no Muni light rail.
[post_title] => Inner Richmond
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => inner-richmond
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 11:04:56
[post_modified_gmt] => 2024-03-19 18:04:56
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12162
[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, 1724982854
ffd_listing_title, 652 4th Avenue, San Francisco, CA, 94118
ffd_mls_id, 424056697
ffd_salesforce_id, a0EUd000002z9GXMAY
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 652 4th Avenue, San Francisco, CA, 94118
pba__address_pb__c, 652 4th Avenue, San Francisco, CA, 94118
agent_only_remarks__c, SHOWINGS: By Appointment-On Supra Lock Box. Call Listing Broker for CBS Code or to schedule Vacant on Supra Lock Box, with CBS Code. Text Steve or call Broker Office-415-564-1380 to get CBS Code. House is vacant and needs work. NO OFFER DATE SET YET. Will Update in the next week. Pre-Escrow Open with Old Republic Title, Ocean Ave. Office; Maria Smith. Disclosures on Disclosures iO; call or write Steve for access. www.flanneryrealestate.com Huge R2 Lot ! Property sold in its present AS IS condition No Offer Date Set Yet. No Preemptive Offers Accepted.
appliances__c, Insulated Water Heater;Free Standing Refrigerator;Gas Plumbed
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1906
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-08-29T19:47:32.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, Inner Richmond Opportunity! Offering tremendous upside opportunity to build a spectacular single family home or for investment units. Plan for a 21st century lifestyle ! A truly special opportunity to build a home in the vibrant Inner Richmond neighborhood in SF. Contractors/Developer's Welcome. This is a unique property in a tremendous location; walking distance to highly desirable Inner Richmond shops, cafes and restaurants. Walk to public transportation and easy access to freeways. The property is situated on a flat 3000 sq. ft. lot; with potential roof deck possibilities. The development opportunity is enormous! Check with the city of SF for building your dream home and the possibilities of adding an ADU within the building envelope? Or for a nanny's quarters?! Potential for creating a private oasis in the City ! Development opportunity awaits ! Currently a one plus story home nestled on one of the most coveted neighborhoods in San Francisco! The existing home boasts high ceilings, 2 Bdrms., Grand living Room, formal dining room,1 Bath, office, Downstairs: Large Garage, Laundry, and delightful garden. No Offer Date Set Yet- No Preemptive Offers Accepted. www.flanneryrealestate.com
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
electric__c, See Remarks
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
height_limit__c, Unknown
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2024-08-30T01:47:05.000+0000
pba__latitude_pb__c, 37.776343
pba__latitude_property__c, 37.776343
laundry_features__c, In Basement;Washer Included;Dryer Included
listed_date__c, 2024-08-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Stephen
pba__listing_agent_lastname__c, Flannery
listing_agent_mls_id__c, 803981
ffd_listingagentname, Stephen D Flannery
listing_agent_number__c, 166013368
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, FLAN
listing_office_name__c, Flannery Real Estate
listing_office_number__c, 166013020
pba__listingprice_pb__c, 999950
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4615797
lower_level__c, Garage
mls_id__c, 424056697
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Tile;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-08-29
original_price__c, 999950
overall_days_on_market__c, -82055
parking_access__c, Tandem
parking_features__c, Enclosed,Garage Facing Front,Size Limited,Tandem Garage,Workshop in Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 985.17
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002z9GXMAY
road_surface_type__c, Asphalt,Paved
roof__c, Bitumen;Shingle
room_type__c, Storage;Office;Kitchen;Living Room;Dining Room;Attic;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1015
size__c, 1015
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, 4th
subdist__c, Inner Richmond
ffd_name, 652 4th Avenue, San Francisco, CA, 94118
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530833513-1.jpg
