meta_query='key:subdist__c;value:Merced Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='382282' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12156
[post_author] => 4
[post_date] => 2018-10-29 01:19:06
[post_date_gmt] => 2018-10-29 01:19:06
[post_content] => A tiny neighborhood, just two blocks by 12 blocks in size. But pay attention to the “Heights” in the name -- that altitude creates views for days. It’s strictly residential, with not even a corner store in the mix.
[post_title] => Merced Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => merced-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 10:03:55
[post_modified_gmt] => 2024-03-19 17:03:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12156
[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, 1725663154
ffd_listing_title, 519 Orizaba Avenue, San Francisco, CA, 94132
ffd_mls_id, 423908536
ffd_salesforce_id, a0EUd0000027XvoMAE
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 519 Orizaba Avenue, San Francisco, CA, 94132
pba__address_pb__c, 519 Orizaba Avenue, San Francisco, CA, 94132
agent_only_remarks__c, 24 HR Notice For Showings-Call or text listing agent--Greg Polchow: 415-846-9542. Pre-Escrow opened with Kevin Thompson at First Amercian Title. https://app.disclosures.io/link/519-Orizaba-Avenue-xf2az0t7
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1963
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-05-24T10:48:13.000+0000
days_on_market__c, 360
dom__c, 81
ffd_description_pb, Perched on top of a hill overlooking the Pacific Ocean, this contemporary Merced Heights home in original condtion backs up to open space on a quiet street with no-thru-traffic. Sweeping panoramic views stretch northward to the Marin Headlands and beyond and include views of much of the city. This tunnel entrance home features ample living space on the main floor, including three bedrooms and two baths, an eat in-kitchen, an open living room with fireplace, and an attached dining area with Pacific Ocean views. The feshly painted and newly carpeted lower level offers additional living space that includes a large family room and upgraded bathroom with separate entrance off inner entry. This house sits on a full lot with rear garden and garage with laundry and interior access. A great opportunity to add your own personal touches.
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Living Room;Brick
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2024-09-06T22:47:29.000+0000
pba__latitude_pb__c, 37.71831
pba__latitude_property__c, 37.71831
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2023-05-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gregory
pba__listing_agent_lastname__c, Polchow
listing_agent_mls_id__c, 807087
ffd_listingagentname, Greg R Polchow
listing_agent_number__c, 166018203
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB3
listing_office_name__c, Sotheby's International Realty Inc
listing_office_number__c, 28227
pba__listingprice_pb__c, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=2F3cHxTGn32&brand=0&mls=1&
pba__longitude_pb__c, -122.46292
lower_level__c, Family Room,Garage,Partial Bath(s)
mls_id__c, 423908536
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-09-12
open_house_end__c, 2024-09-08T16:00:00.000+0000
open_house_start__c, 2024-09-08T13:00:00.000+0000
original_price__c, 1205000
overall_days_on_market__c, -81703
parking_access__c, Independent
parking_features__c, Attached,Covered,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
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, 981.95
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000027XvoMAE
road_surface_type__c, Asphalt
sale_date__c, 1800-01-01
sale_price__c, 0
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, 1828
size__c, 1828
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Orizaba
subdist__c, Merced Heights
ffd_name, 519 Orizaba Avenue, San Francisco, CA, 94132
view__c, Ocean;City;Panoramic;San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1963
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530675684-1.jpg