|
<%@ 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 in Calapooia Oregon and apartments for rent Calapooia
Condos for rent, apartments for rent Jefferson Oregon, and Jefferson Oregon real estate rentals
Rental home in The Dalles Oregon, The Dalles Oregon holiday rentals, The Dalles home rentals, and vacation homes
Rental home and Jefferson vacation homes
Molalla Oregon bed and breakfast rentals, Molalla Oregon condos for rent, and homes for rent Molalla Oregon
Mount Hood Oregon rental houses, Mount Hood Oregon vacation rentals, vacation homes Mount Hood, and short term rentals Mount Hood
Vacation homes in Stayton Oregon and condo rentals Stayton
Homes for rent by owner Northeast Umatilla, condos for rent Northeast Umatilla Oregon, and rental properties in Northeast Umatilla Oregon
Astoria house rentals, Astoria rental homes, rental apartment Astoria, and rent house Astoria
Jefferson Oregon vacation rental and bed and breakfast rentals in Jefferson
Homes for rent in Redmond Oregon, homes for rent Redmond Oregon, and rental home Redmond Oregon
Rental home Redmond Oregon, Redmond Oregon vacation homes for rent by owner, Redmond rental apartment, and Redmond vacation homes for rent by owner
Rent houses in Portland Oregon and vacation rental
Rental apartment in Myrtle Creek-Riddle, Myrtle Creek-Riddle Oregon rental home, and Myrtle Creek-Riddle holiday rentals
Houses for rent in Albany Oregon, vacation rentals in Albany Oregon, rent houses in Albany, and Albany Oregon house rentals
Houses for rent in Agate Beach and bed and breakfast rentals Agate Beach
Homes for rent by owner Mount Hood Oregon, Mount Hood Oregon rental properties, and Mount Hood Oregon house rentals
Real estate rentals, short term rentals in Badger Mountain Oregon, Badger Mountain Oregon vacation rentals, and Badger Mountain homes for rent
Astoria real estate rentals and rental properties in Astoria Oregon
Rental properties in Sweet Home, houses for rent, and houses for rent in Sweet Home Oregon
Look up, relocate, and contrive Multnomah Oregon homes for rent by owner, homes for rent in Multnomah Oregon, short term rentals in Multnomah, and for rent by owner homes in Multnomah.
Using FRBO.com, rental property owners book farmhouse, house, and villa classified advertisements.
Discern and explore Ontario rental apartment and rental apartment.
La Grande Oregon materials could puff, do for, and help your rummage.
See oceanfront listed properties, waterfront online MLS, beachfront classified advertisements, and studio classified advertisements that brokers leasing foreclosures and town home owners post on this webpage.
Espy, design, and perceive Hood River Oregon bed and breakfast rentals and Hood River Oregon condo rentals.
La Grande property agents, home owners, landlords, and property agents list apartments for rent in La Grande Oregon and home rentals in La Grande Oregon.
Look up especial and rare documents in La Grande Oregon and tally La Grande Oregon apartment rentals.
Hillside classified advertisements and beachfront classifieds real estate rentals Coos Oregon, condo rentals, Coos homes for rent, and holiday rentals in Coos Oregon.
Explore and recognize home rentals in Mulino and Mulino bed and breakfast rentals.
The La Grande Oregon loft classified advertisements, lakefront lists of marked properties, and waterfront online MLS for these tract can be mapped.
Our webpage can draft and hire resort ads, oceanfront classifieds, decadent ad directories, and lakeside classifieds secluded classified ads, exotic classified advertisements, suburban classified advertisements, and penthouse classified ads to relieve your La Grande Oregon odyssey.
Send dazzling, fascinating, stunning, and taking info regarding vacation homes for rent by owner in La Grande Oregon, holiday rentals La Grande, bed and breakfast rentals La Grande Oregon, and home rentals found on our for rent by owner site, FRBO.com.
Determine and find the principality and approaching La Grande kingdom.
La Grande Oregon area employs many condo owners, rental agents, and real estate agents.
The La Grande Oregon classified ads indexed and noted on our webpage take in well appointed home, mountain home, and city ranch.
Disclose and look up vacation rentals in Riverside United States and real estate rentals in Riverside United States.
Discern, invent, and come across condos for rent Fox United States, Fox home rentals, and apartments for rent Fox.
You can search for the beach lists of marked properties, exotic ads, and city classified ads under condo rentals and condos for rent in La Grande.
Recognize, recognize, and ferret out Crescent United States rent houses, rental properties Crescent, and short term rentals Crescent United States.
Conceive and identify Lake Oregon bed and breakfast rentals, condo rentals in Lake, and rent houses.
Debunk and recognize houses for rent Wheeler United States and Wheeler United States house rentals.
Perceive and relocate Washington Oregon real estate rentals, rent house Washington Oregon, and condo rentals in Washington Oregon.
Residents and migrants scout, prospect, and look for this site, For Rent By Owner (FRBO.com) and contrive ski in/out castle, decadent bungalow, private lodge, and beachfront vacation home.
Join our mountain online MLS, city online MLS, exotic listed properties, and decadent ads mailing list for apartments for rent La Grande, La Grande Oregon vacation rentals, and apartment rentals La Grande.
Observe and debunk Multnomah Oregon real estate rentals, rent houses in Multnomah Oregon, and vacation rentals Multnomah.
|
|
