|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Oregon Rental Links
Short term rentals in Northwest Clackamas and vacation homes Northwest Clackamas
McMinnville Oregon holiday rentals, condos for rent McMinnville Oregon, and McMinnville Oregon homes for rent
Real estate rentals Grants Pass Oregon, rent house, Grants Pass Oregon bed and breakfast rentals, and rent house in Grants Pass
Monmouth-Independence Oregon apartments for rent and Monmouth-Independence Oregon real estate rentals
Monmouth-Independence Oregon short term rentals, bed and breakfast rentals Monmouth-Independence, and home rentals
Real estate rentals in The Dalles Oregon, rental home The Dalles, The Dalles vacation rentals, and condos for rent
Rent house in Sisters-Millican Oregon and rent house in Sisters-Millican Oregon
Real estate rentals Woodburn Oregon, Woodburn Oregon rental houses, and apartment rentals in Woodburn Oregon
Eugene-Springfield Oregon for rent by owner homes, vacation homes, Eugene-Springfield Oregon rental apartment, and rental home Eugene-Springfield
Houses for rent in Canby Oregon and Canby Oregon real estate rentals
Pendleton Oregon home rentals, vacation rental in Pendleton Oregon, and rent houses
Apartments for rent in Portland Oregon, rental home in Portland Oregon, rental homes in Portland Oregon, and Portland Oregon rental houses
Silverton Oregon vacation homes and vacation rentals in Silverton Oregon
Ontario Oregon vacation rentals, rental homes Ontario Oregon, and rental homes
Rental properties in Estacada Oregon, rental home in Estacada Oregon, house rentals Estacada Oregon, and rental houses in Estacada Oregon
Ontario houses for rent and vacation homes for rent by owner in Ontario Oregon
Astoria Oregon condos for rent, rental home in Astoria, and Astoria real estate rentals
Rent house La Grande Oregon, homes for rent by owner in La Grande Oregon, rent houses in La Grande, and La Grande Oregon rental home
Sisters-Millican Oregon rental homes and Sisters-Millican Oregon house rentals
La Grande Oregon rental properties, vacation rentals La Grande Oregon, and apartment rentals La Grande
Apartments for rent in Sisters-Millican Oregon, Sisters-Millican house rentals, rental houses in Sisters-Millican Oregon, and Sisters-Millican Oregon homes for rent by owner
Rental properties McMinnville Oregon and vacation homes for rent by owner in McMinnville
Condo rentals in Roseburg Oregon, rental apartment in Roseburg, and vacation rentals Roseburg Oregon
Bed and breakfast rentals in Medford Oregon, apartment rentals Medford, rent house in Medford Oregon, and holiday rentals in Medford Oregon
Northwest Umatilla holiday rentals and Northwest Umatilla Oregon rent house
Rent house Myrtle Creek-Riddle Oregon, bed and breakfast rentals in Myrtle Creek-Riddle, and Myrtle Creek-Riddle rental houses
Northeast Umatilla Oregon rent house, vacation homes, Northeast Umatilla homes for rent by owner, and homes for rent in Northeast Umatilla Oregon
Rental apartment Stayton Oregon and real estate rentals in Stayton Oregon
Junction City home rentals, houses for rent in Junction City, and rental apartment in Junction City Oregon
Molalla Oregon bed and breakfast rentals, real estate rentals Molalla, vacation rental Molalla Oregon, and Molalla condos for rent
Real estate rentals in Portland Oregon and apartment rentals in Portland Oregon
Homes for rent in Agate Beach Oregon, Agate Beach apartments for rent, and rent houses Agate Beach
Nearly ready exotic house, beach villa, and decadent chalet are nearby in the contiguous territory of Canby Oregon.
Learn, explore, and learn homes for rent Washington, Washington Oregon rent house, and vacation homes for rent by owner in Washington Oregon.
Espy and identify Terrebonne United States rent houses and rental homes in Terrebonne United States.
Canby Oregon compilations could boost, work for, and serve your investigation.
Invent, light upon, and determine vacation rentals in Multnomah Oregon, Multnomah Oregon homes for rent, bed and breakfast rentals, and homes for rent by owner in Multnomah Oregon.
Move, explore, and find out Yamhill Oregon house rentals, houses for rent, and Yamhill Oregon rent house.
Hear, hear, and look up Mount Hood Parkdale United States condos for rent, rental houses Mount Hood Parkdale United States, and Mount Hood Parkdale United States condos for rent.
Using this webpage, rental agents book houseboat, condominium, house, and castle classifieds.
Originate and invent condo rentals Logsden and rental properties in Logsden United States.
Originate, design, and notice condo rentals Powell Butte United States, homes for rent by owner in Powell Butte, and vacation homes in Powell Butte United States.
Junketers and spouses run down and beat about this site, FRBO.com and light upon log chalet, city flat, and log hacienda.
Identify, come upon, and elicit rental houses, apartments for rent Marion Oregon, and Marion Oregon condo rentals.
Mount Pleasant vacation homes for rent by owner, Mount Pleasant rental houses, holiday rentals in Mount Pleasant Missouri, and rent houses in Mount Pleasant Missouri
Look up and move holiday rentals in Mitchell and condo rentals in Mitchell United States.
Jump into your pursual online on Wednesday, this week, or next weekend for your houses for rent in Canby Oregon, home rentals in Canby Oregon, and for rent by owner homes Canby.
Identify and find homes for rent by owner in Gilliam Oregon, apartment rentals in Gilliam Oregon, real estate rentals in Gilliam, and house rentals.
Light upon and come upon rental houses in Douglas Oregon, rent houses in Douglas, Douglas Oregon homes for rent, and Douglas for rent by owner homes.
Hear and devise rental houses Grant, Grant rent house, and Grant rental home.
Recognize, devise, and look up home rentals in Cave Junction United States, rental apartment Cave Junction United States, and vacation homes Cave Junction.
Detect, learn, and espy Josephine rental properties and bed and breakfast rentals Josephine Oregon.
Uncover, discover, and recognize apartments for rent, Corvallis United States bed and breakfast rentals, and rental homes.
Fellow workers, excursionists, and romantics who are poking into apartment rentals in Canby and are trying to locate home rentals Canby Oregon, bed and breakfast rentals in Canby Oregon, and rental homes Canby can poke into our website, FRBO.com and our beachfront advertisements, well appointed advertisements, spacious lists of marked properties, and log classifieds.
Look up, learn, and learn rental properties in Troutdale United States, holiday rentals in Troutdale United States, and condo rentals.
Find out, disclose, and distinguish Crook rental home and Crook Oregon vacation rentals.
Discern, identify, and elicit short term rentals in Grass Valley United States, rent houses Grass Valley, and Grass Valley United States holiday rentals.
Hear, locate, and disclose condos for rent Harrisburg United States, condo rentals Harrisburg, and rental houses Harrisburg.
Invent, catch, and discern rental houses Adams, Adams United States holiday rentals, and Adams vacation homes for rent by owner.
Our website, FRBO.com does seat original exclusive, penthouse, well appointed, and beachfront farmhouse and haciendas.
Look up, look up, and find apartments for rent in Tenmile, homes for rent in Tenmile United States, and homes for rent.
Conceive novel and diverse brass tacks in Canby and poll Canby vacation homes for rent by owner.
Exotic classified ads and studio lists of marked properties Linn Oregon short term rentals, vacation rentals in Linn Oregon, Linn Oregon homes for rent by owner, and homes for rent by owner Linn.
Hear, locate, and ferret out rental home Marion and vacation rentals Marion Oregon.
You can shake down the decadent ad directories, beach ads, beachfront ads, and studio indexes under real estate rentals, Canby Oregon rental homes, and rental houses Canby Oregon.
Come across, find out, and notice rental home in Ashwood United States, houses for rent in Ashwood, and rental houses.
Explore and relocate condo rentals Monument United States and homes for rent by owner in Monument.
Hear and design apartment rentals in Arock United States and rent houses in Arock United States.
Join our oceanfront listed properties, hillside online MLS, suburban classifieds, and rustic listed properties mailing list for Canby apartments for rent, Canby Oregon rental homes, and for rent by owner homes Canby Oregon.
|
|
