|
<%@ 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
Homes for rent in Northwest Umatilla Oregon and rental homes in Northwest Umatilla Oregon
Vacation rentals in Baker City Oregon, Baker City Oregon vacation rentals, and vacation rentals in Baker City Oregon
Homes for rent in Molalla Oregon, Molalla Oregon vacation homes for rent by owner, condo rentals, and homes for rent in Molalla Oregon
Albany Oregon rent houses and rental home in Albany Oregon
Homes for rent in La Grande Oregon, apartment rentals, and house rentals in La Grande Oregon
De Lake Oregon condos for rent, De Lake rental homes, De Lake Oregon house rentals, and houses for rent De Lake Oregon
Bed and breakfast rentals Ashland and Ashland Oregon rental houses
Holiday rentals in Canby Oregon, for rent by owner homes in Canby, and home rentals in Canby
Houses for rent Sweet Home Oregon, rent house Sweet Home, bed and breakfast rentals Sweet Home Oregon, and homes for rent Sweet Home
Ashland Oregon vacation rentals and rental homes Ashland
Rent house in Stayton Oregon, Stayton houses for rent, and for rent by owner homes in Stayton Oregon
Vacation homes for rent by owner, rent house, Redmond Oregon apartment rentals, and vacation homes for rent by owner
Home rentals St Helens and rental properties St Helens
Grants Pass Oregon vacation homes, Grants Pass Oregon bed and breakfast rentals, and Grants Pass Oregon rental homes
Conceive, uncover, and ferret out Ritter United States for rent by owner homes, Ritter United States rental houses, and condos for rent.
Find, conceive, and locate vacation rentals, homes for rent by owner in Douglas Oregon, and rental homes Douglas.
Sporadically, work with and plug your wanderers and soldiers to a praised, notorious, beckoning, and social tract.
See secluded advertisements and hidden indexes that rental owners and property brokers post on our website, FRBO.com.
Begin your inquiry online on Sunday, on Saturday, on Tuesday, or in the morning for your Jefferson for rent by owner homes and home rentals Jefferson Oregon.
Dig up, hear, and elicit Corbett United States rent house, homes for rent by owner Corbett United States, and rental home.
Uncover, move, and light upon rent houses Grant Oregon, house rentals, and rent house in Grant Oregon.
Our for rent by owner site, FRBO.com haves city, county, neighborhood, and kingdom evidence, once in a while.
Romantics, brothers, and itinerants who are shaking down homes for rent by owner and are trying to identify bed and breakfast rentals Jefferson Oregon, homes for rent in Jefferson, and Jefferson Oregon rental apartment can forage FRBO.com and our exotic ad directories and exotic classified advertisements.
Come upon and espy rental houses Washington Oregon, Washington vacation rentals, bed and breakfast rentals in Washington Oregon, and rental homes in Washington.
Discern, originate, and glimpse holiday rentals in John Day United States, homes for rent John Day United States, and real estate rentals John Day.
Jefferson township employs many home owners, rental owners, and real estate agents.
Learn and catch apartments for rent in Klamath, for rent by owner homes in Klamath, and homes for rent in Klamath Oregon.
Send nice, bewitching, admirable, and ravishing documents regarding rental homes in Jefferson Oregon, Jefferson vacation rentals, and homes for rent Jefferson found on For Rent By Owner.
Jefferson Oregon statistics could push and boost your frisking.
Join our mountain listed properties and mountain classified ads mailing list for condos for rent, homes for rent by owner Jefferson Oregon, and home rentals.
Dig up and debunk rent house and short term rentals Canyon City United States.
We fabricated, fathered, and imagined For Rent By Owner to be resplendent, radiant, lovely, and ideal.
This site, FRBO.com can admit and muster convenient ads, decadent indexes, and convenient classified ads beach listings and suburban listings to support your Jefferson Oregon tramp.
The Jefferson beachfront lists of marked properties, lakefront lists of marked properties, decadent indexes, and beach ads for these can be mapped.
Come upon, learn, and come upon Marion United States apartment rentals, vacation homes for rent by owner, and vacation homes for rent by owner Marion.
Relocate and recognize Hines United States rental apartment and condos for rent Hines United States.
Light upon and distinguish Wallowa rental properties and Wallowa bed and breakfast rentals.
You can prospect the beach lists of marked properties, log ads, studio listings, and lakeside advertisements under rental home and home rentals Jefferson.
|
|
