DEBUG
FN args: Array
(
[0] => 3020
[1] =>
[2] =>
[3] => agent
)
BEFORE:
Site: 3020
LocID:
Region:
State: agent
Experttype:
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
SITE IS NUMERIC, SWAPPING
IFELSE numeric
IFELSE else
AFTER:
Site: 3020
Igate: njhud
LocID: 3020
Region:
State:
Experttype: agent
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3020 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG
FN args: Array
(
[0] => 3020
[1] =>
[2] =>
[3] => lender
)
BEFORE:
Site: 3020
LocID:
Region:
State: lender
Experttype:
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
SITE IS NUMERIC, SWAPPING
IFELSE numeric
IFELSE else
AFTER:
Site: 3020
Igate: njhud
LocID: 3020
Region:
State:
Experttype: lender
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3020 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
DEBUG
FN args: Array
(
[0] => 3020
[1] =>
[2] =>
[3] => other
)
BEFORE:
Site: 3020
LocID:
Region:
State: other
Experttype:
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
SITE IS NUMERIC, SWAPPING
IFELSE numeric
IFELSE else
AFTER:
Site: 3020
Igate: njhud
LocID: 3020
Region:
State:
Experttype: other
Expertnum: 1
ProcessOverride: 1
SearchNearby:
DisplayCount: 1
QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3020 AND i.igate IN ('tnhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
1
540 Roth Road
Parkersburg
WV
26104
USHUD.com property -
Agency: Berkshire Hathaway HomeServices Professional Realty
Agency Phone: (304) 428-7653
Case Number: 3yd-NEOHREXOH-4147395
Property Status: Active
List Price: 1,600,000
https://njhud.com//homes/west-virginia/wood/parkersburg/540-roth-road?aid=6408993
540 Roth Road
Parkersburg,
WV
26104
Property Details
List Price: |
$1,600,000 |
Beds: |
-- |
Baths: |
-- |
Status: |
Active |
SqFt: |
-- |
Agency: |
Berkshire Hathaway HomeServices Professional Realty |
Agency Phone: |
(304) 428-7653 |
Description/Comments
Lot Size: |
89 acre(s) |
Property Type: |
Commercial Sale-Other |
Year Built: |
1995 |
Notes: |
This property is located at Rt. 77 and Rt. 50. With the location traffic count and visual exposure, it is one of the prime properties in the state for commercial development. All utilities are available on site. |
MlsNumber: |
-- |
ListingId: |
4147395 |
Estimate Your Monthly Payment
Listing Provided By: |
Berkshire Hathaway HomeServices Professional Realty, original listing |
Phone: |
(304) 482-7500 |
Office Phone: |
(304) 428-7653 |
Agent Name: |
Steven Shaver |
Disclaimer: |
Copyright © 2025 MLS Now. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified. |