meta_query='key:subdist__c;value:Ingleside Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='350022' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70658
[post_author] => 4
[post_date] => 2018-11-30 20:30:32
[post_date_gmt] => 2018-11-30 20:30:32
[post_content] => Ingleside is a lot more down-to-earth than some of its swankier neighbors to the north, and it’s also a lot more affordable. Homes tend to be modest, some in the same family for generations. Unexpected views of downtown add to the attraction of this more-affordable neighborhood, which also has great public transit options and easy freeway access.
[post_title] => Ingleside Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:51:10
[post_modified_gmt] => 2024-04-09 18:51:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70658
[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, 1707911713
ffd_listing_title, 454 Orizaba Avenue, San Francisco, CA, 94132
ffd_mls_id, 423921647
ffd_salesforce_id, a0EUd000000Oz3xMAC
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 454 Orizaba Avenue, San Francisco, CA, 94132
pba__address_pb__c, 454 Orizaba Avenue, San Francisco, CA, 94132
agent_only_remarks__c, Owner works nights. Would you, therefore, try to adhere showings to open houses. If your client cannot make any of the open houses, please let me know in advance, and we'll try to accommodate. Please do not disturb occupant otherwise. Thank you! Disclosures: https://app.disclosures.io/link/454-Orizaba-Avenue-i8s7149q Bedroom downstairs and library are unwarranted. Buyer to check all square footage and building history to their own satisfaction. Offers welcome at 10 a.m. on December 20th. Please submit a signed disclosure cover sheet, proof of funds and pre-approval letter along with the latest SFAR Purchase Agreement. Thank you!
appliances__c, Gas Water Heater;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1953
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-12-07T11:47:41.000+0000
days_on_market__c, 69
dom__c, 14
ffd_description_pb, Stylish and spacious 3-bedroom home featuring new paint inside and out, showcasing views from every window and ocean views from the dining and living rooms. Cozy up in the living room and enjoy your beautiful fireplace on a cold evening. The kitchen offers a new quartz countertop. This level also houses three bedrooms on the same level, a rare find, and a bathroom. Downstairs, an additional bedroom offers privacy next to the garage. A retreat/library/office awaits your moments of solitude on the way to the backyard. Entertain on the large deck overlooking the rear yard, great for parties or barbecues, while admiring the little houses perched on the hill to the east. This property also offers a spacious yard ideal for gardening enthusiasts. Completing the features are a new roof and a one-car garage with ample storage. This home is conveniently located close to the Ocean commercial corridor in the north and school, park, H Mart, public transportation, library, and the 280 fwy in the south. Don't miss out! Come check it out!
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter
electric__c, 220 Volts,220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Chain Link
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Other
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-02-14T11:47:48.000+0000
pba__latitude_pb__c, 37.7169148
pba__latitude_property__c, 37.7169148
laundry_features__c, In Garage
listed_date__c, 2023-11-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ana
pba__listing_agent_lastname__c, Roqueta
listing_agent_mls_id__c, 808250
ffd_listingagentname, Ana M Roqueta
listing_agent_number__c, 1032505
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 849000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4624477
lower_level__c, Bedroom(s),Garage,Retreat
mls_id__c, 423921647
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-12-07
original_price__c, 849000
overall_days_on_market__c, -81789
parking_access__c, Independent
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2023-12-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 877.96
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000000Oz3xMAC
road_surface_type__c, Paved
roof__c, Bitumen
room_type__c, Kitchen;Library;Living Room
sale_date__c, 2024-01-17
sale_price__c, 1000000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, EB286235
selling_agent_number__c, 981313938
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Re/Max Accord
pba__status__c, Closed
pba__totalarea_pb__c, 1139
size__c, 1139
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Orizaba
subdist__c, Ingleside Heights
ffd_name, 454 Orizaba Avenue, San Francisco, CA, 94132
view__c, Ocean;City Lights;Hills
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1953
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530708922-1.jpg