meta_query='key:subdist__c;value:Merced Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='345449' 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, 1699704591
ffd_listing_title, 732 Shields Street, San Francisco, CA, 94132
ffd_mls_id, 423916872
ffd_salesforce_id, a0E8W00000dUarhUAC
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 732 Shields Street, San Francisco, CA, 94132
pba__address_pb__c, 732 Shields Street, San Francisco, CA, 94132
agent_only_remarks__c, Vacant, staged and on Supra lockbox. Probate. Please note: NO court confirmation is required. Turn key for your today buyers with expansion potential. Please reach out to Paula for more info- Voice/text at 415-724-3424, email [email protected].
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-16T16:47:03.000+0000
days_on_market__c, 26
dom__c, 9
ffd_description_pb, Adorable + Affordable. Welcome home to 732 Shields. This updated three-bedroom, 1.5-bathroom single-family home is a sanctuary of modern comfort and style, nestled near the picturesque Merced Heights Playground. Offering a perfect blend of urban convenience and suburban tranquility. Formal dining room, kitchen with stainless steel appliances. Living room with wood burning fireplace. Bathroom has both a tub and separate shower. Seated make up area off the primary bedroom. Both bedrooms on the upper level overlook the garden with some ocean views. Bedroom on the lower level has 1/2 bath with a garden view. Large garage has a laundry area and parking for 3 cars tandem. There is plenty of storage with expansion potential. Steps from the Merced Heights playground with basketball, tennis, volleyball and classes. Easy access to MUNI and 280 freeway. Close to Stonestown with Whole Foods, Trader Joes, Peet's, Apple and more. Affordable, adorable and ready for you. 732 Shields, when you're here, you're home.
district__c, SF District 3
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-11-11T11:48:09.000+0000
pba__latitude_pb__c, 37.7180636
pba__latitude_property__c, 37.7180636
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2023-10-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Paula
pba__listing_agent_lastname__c, Rose
listing_agent_mls_id__c, 802963
ffd_listingagentname, Paula Y Rose
listing_agent_number__c, 802963
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28936
pba__listingprice_pb__c, 878000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4695198
lower_level__c, Bedroom(s),Garage,Partial Bath(s),Street Entrance
mls_id__c, 423916872
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Dining Room
master_bathroom_features__c, Shower Stall(s);Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2023-10-16
original_price__c, 878000
overall_days_on_market__c, -81737
parking_access__c, Independent
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-10-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-11-10T16:01:48.000+0000
price_per_square_foot__c, 904.35
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dUarhUAC
sale_date__c, 2023-11-09
sale_price__c, 1040000
selling_agent_mls_id__c, 808467
selling_agent_number__c, 1035533
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, 1150
size__c, 1150
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Shields
subdist__c, Merced Heights
ffd_name, 732 Shields Street, San Francisco, CA, 94132
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530692971-1.jpg
