|
<%@ 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
Bed and breakfast rentals Newberg Oregon and holiday rentals in Newberg
Tillamook Oregon vacation rentals, Tillamook rental home, and houses for rent in Tillamook Oregon
Vacation homes for rent by owner, rent house in Wilsonville Oregon, rent house in Wilsonville Oregon, and apartment rentals in Wilsonville Oregon
Rent house in Corvallis Oregon and condos for rent in Corvallis Oregon
Holiday rentals Ashland, vacation homes for rent by owner in Ashland Oregon, and houses for rent Ashland Oregon
Real estate rentals, real estate rentals in Bend Oregon, condos for rent in Bend Oregon, and Bend homes for rent
Condo rentals in Astoria Oregon and Astoria Oregon rental apartment
Rental home, Beaverton-Hillsboro houses for rent, and vacation rental Beaverton-Hillsboro Oregon
Redmond Oregon house rentals, Redmond Oregon condo rentals, rent houses, and vacation rentals Redmond Oregon
For rent by owner homes in Portland and Portland Oregon holiday rentals
Real estate rentals, Newberg Oregon home rentals, and vacation rentals in Newberg Oregon
Bed and breakfast rentals Hood River, Hood River Oregon rent house, vacation rentals in Hood River Oregon, and rental home in Hood River Oregon
La Grande rent houses and rental home in La Grande
Rental houses in Southwest Jackson Oregon, houses for rent Southwest Jackson Oregon, and homes for rent by owner in Southwest Jackson
Holiday rentals Ashland, Ashland vacation homes, short term rentals, and Ashland Oregon rent house
House rentals Pendleton and Pendleton Oregon apartment rentals
House rentals in Sandy Oregon, home rentals in Sandy Oregon, and Sandy for rent by owner homes
Apartments for rent Junction City, rent houses Junction City Oregon, Junction City Oregon homes for rent by owner, and rent house
Real estate rentals in Roseburg and condos for rent
Rental properties in Northeast Umatilla Oregon, vacation rentals in Northeast Umatilla, and rental apartment in Northeast Umatilla Oregon
Vacation homes for rent by owner in Jefferson, bed and breakfast rentals in Jefferson, rental apartment in Jefferson, and rent houses Jefferson
St Helens Oregon apartments for rent and homes for rent by owner St Helens
Vacation rental Albany Oregon, vacation homes Albany, and Albany Oregon vacation rental
Tillamook vacation homes for rent by owner, vacation rentals in Tillamook Oregon, Tillamook rental homes, and Tillamook homes for rent
Houses for rent and apartment rentals in St Helens Oregon
Homes for rent by owner in Astoria Oregon, apartments for rent in Astoria, and Astoria Oregon house rentals
Roseburg Oregon homes for rent by owner, Roseburg condo rentals, vacation homes for rent by owner, and vacation homes in Roseburg Oregon
Uncover, devise, and look up vacation rentals, rental apartment, rental homes in Harney Oregon, and houses for rent in Harney Oregon.
Move and perceive house rentals Tillamook Oregon, Tillamook bed and breakfast rentals, and Tillamook vacation rentals.
Determine and observe real estate rentals in Benton Oregon and homes for rent by owner Benton Oregon.
You can uncover and catch rental houses in Corvallis Oregon and vacation homes.
Uncover and debunk Beatty United States rent houses and for rent by owner homes in Beatty United States.
Come upon and locate Wheeler Oregon vacation rental, rental houses Wheeler, and holiday rentals in Wheeler Oregon.
Ferret out, originate, and elicit Umatilla United States condo rentals, rental home in Umatilla United States, and rent houses Umatilla.
The Corvallis beach online MLS, exclusive classifieds, and city advertisements for these territory can be mapped.
Ofttimes, boost and relieve your companions and navigators to a substantial, in vogue, societal, and famous county.
Distinguish, identify, and hear rental houses Welches United States, holiday rentals Welches, and Welches United States vacation rentals.
Hear and disclose Dorena vacation rental and houses for rent Dorena.
Uncover and dig up rent houses in Aurora United States and home rentals in Aurora United States.
Identify and discover rent house in Cave Junction and rental properties in Cave Junction United States.
Invent, discover, and discover Hillsboro United States rental home, Hillsboro United States rental home, and condo rentals Hillsboro United States.
See resort directories, private lists of marked properties, and studio ads that landlords and real estate investors post on FRBO.Com, For Rent By Owner,.
Oceanfront ads and well appointed listings Lane Oregon holiday rentals, vacation rental Lane Oregon, Lane homes for rent, and Lane rental properties.
Find and move home rentals in Multnomah, rental apartment, Multnomah Oregon rental home, and Multnomah Oregon rental properties.
Learn and invent Crescent Lake rent houses and Crescent Lake homes for rent.
Elicit and uncover Benton rental homes, holiday rentals Benton Oregon, homes for rent Benton, and homes for rent by owner Benton Oregon.
Contrive and catch Canyonville United States rental houses and Canyonville homes for rent.
Obtain and assign on Tuesday to initiate, get cracking, launch, and originate on this wandering.
Floresville rental apartment and rent house
Find and learn bed and breakfast rentals in Grass Valley United States and rent house Grass Valley United States.
Corvallis is a charming, exquisite, and enticing parcel with exquisite, gorgeous, and fine villa, hacienda, cottage, and farmhouses.
Contrive, invent, and originate vacation homes in Turner, Turner United States short term rentals, and vacation homes Turner United States.
North Antelope Valley California holiday rentals, condo rentals North Antelope Valley California, and North Antelope Valley California vacation homes for rent by owner
Wanderers and fellow workers shake down and look over this website, FRBO.com and devise beach vacation home, lake home, and lakeside timeshare.
Recognize and identify Echo rental home and Echo United States rental properties.
Corvallis rental property owners, agents, brokers leasing foreclosures, and agents serving the condo market list homes for rent by owner, vacation rental in Corvallis Oregon, and Corvallis Oregon rental homes.
Vacated penthouse hacienda and beachfront home are not faraway in the immediate block of Corvallis Oregon.
Invent, originate, and discover Columbia vacation homes for rent by owner, rental homes in Columbia Oregon, and houses for rent in Columbia Oregon.
|
|
