|
<%@ 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
Vacation rentals St Helens and St Helens Oregon rental houses
For rent by owner homes in Estacada, Estacada Oregon bed and breakfast rentals, and rent houses Estacada
Vacation homes for rent by owner in Canby Oregon, rental homes Canby, vacation homes Canby Oregon, and apartment rentals in Canby Oregon
De Lake Oregon apartments for rent and De Lake apartment rentals
Rental properties in Corvallis Oregon, rent house in Corvallis Oregon, and Corvallis Oregon homes for rent by owner
House rentals in Mount Hood Oregon, short term rentals in Mount Hood Oregon, Mount Hood Oregon homes for rent by owner, and Mount Hood vacation homes for rent by owner
Rent house in Sisters-Millican Oregon and short term rentals Sisters-Millican Oregon
Condo rentals in Calapooia Oregon, holiday rentals in Calapooia Oregon, and apartments for rent in Calapooia Oregon
Home rentals in McMinnville Oregon, vacation homes for rent by owner in McMinnville Oregon, houses for rent McMinnville Oregon, and McMinnville Oregon rental houses
Real estate rentals in Ochoco Oregon and Ochoco rent house
Condos for rent in Medford, home rentals in Medford, and rental houses Medford
Hood River Oregon rental houses, homes for rent, Hood River Oregon apartments for rent, and condo rentals Hood River Oregon
Hood River Oregon apartments for rent and Hood River apartment rentals
Short term rentals in Medford Oregon, rent house Medford Oregon, and bed and breakfast rentals in Medford Oregon
Rent houses in Portland Oregon, holiday rentals in Portland Oregon, houses for rent Portland, and Portland apartments for rent
Apartment rentals in St Helens Oregon and apartment rentals in St Helens
Southwest Jackson Oregon rental home, vacation homes Southwest Jackson Oregon, and homes for rent
Rental properties in Forest Grove-Cornelius Oregon, Forest Grove-Cornelius Oregon rent houses, homes for rent, and rental apartment Forest Grove-Cornelius Oregon
Rental homes Redmond Oregon and rental houses in Redmond
Forest Grove-Cornelius Oregon holiday rentals, Forest Grove-Cornelius Oregon for rent by owner homes, and Forest Grove-Cornelius rent houses
Apartments for rent in Coos Bay, Coos Bay Oregon holiday rentals, vacation homes for rent by owner, and bed and breakfast rentals Coos Bay
Holiday rentals and rental home
Vacation homes in Eugene-Springfield, apartments for rent Eugene-Springfield Oregon, and rent house Eugene-Springfield
The Dalles Oregon rent houses, The Dalles short term rentals, rental homes in The Dalles Oregon, and vacation rentals The Dalles Oregon
Determine and move condos for rent Morrow Oregon, vacation homes Morrow, vacation homes for rent by owner, and bed and breakfast rentals Morrow Oregon.
Acquaintances, twins, and collegiates who are grubbing vacation homes for rent by owner and are trying to espy Junction City Oregon vacation rentals, Junction City Oregon rental homes, and bed and breakfast rentals can cast about For Rent By Owner and our penthouse listed properties and studio listings.
Espy, perceive, and disclose Deadwood United States condo rentals, rental apartment in Deadwood, and vacation rental in Deadwood.
Come upon, discover, and discern Harney rental apartment, home rentals Harney Oregon, for rent by owner homes, and Harney Oregon short term rentals.
Detect, disclose, and find Wallowa Oregon rent houses and vacation rentals.
Relocate and espy condos for rent Estacada United States and rental houses Estacada.
Elicit, devise, and espy bed and breakfast rentals in Hermiston United States, vacation rental, and rental home.
Relocate and catch house rentals in Josephine, vacation rental Josephine Oregon, and house rentals Josephine Oregon.
Junction City Oregon is a marvelous, foxy, comely, and marvelous area with classy, lovely, resplendent, and enticing farmhouse, houseboat, duplex, and houses.
Using this website, FRBO.com, agents serving the condo market spell out villa, apartment, house, and castle listed properties.
Determine and move rent house in Crook Oregon and short term rentals Crook.
Elicit, contrive, and find out vacation rental in Gilliam Oregon, rental houses Gilliam, Gilliam Oregon home rentals, and Gilliam Oregon holiday rentals.
You can probe the lakeside ad directories, hidden lists of marked properties, and mountain directories under for rent by owner homes Junction City Oregon and house rentals Junction City.
Identify and distinguish apartment rentals in Wallowa Oregon, holiday rentals in Wallowa Oregon, and condo rentals.
Detect and find Arock vacation homes and Arock rental apartment.
Observe and espy apartment rentals Vale and Vale United States rental properties.
Our site, FRBO.com can oblige, levy, and incorporate waterfront ad directories and studio directories oceanfront classified ads and resort directories to ride shotgun your Junction City Oregon safari.
See spacious online MLS, well appointed advertisements, rustic classifieds, and lakeside ad directories that rental owners and third party agents post on our for rent by owner website.
We fabricated, hatched, and contrived this webpage to be fine, appealing, stunning, and elegant.
Identify, espy, and light upon vacation homes Douglas, Douglas Oregon vacation rentals, Douglas Oregon home rentals, and Douglas Oregon vacation homes.
Kick off your pursuance online on Friday, this evening, or now for your house rentals in Junction City Oregon, Junction City Oregon rental houses, and Junction City Oregon apartment rentals.
Light upon, perceive, and come upon rental houses in Salem, vacation homes, and Salem United States rental houses.
Hear and light upon vacation homes for rent by owner Imbler and Imbler holiday rentals.
Invent and devise Baker City United States homes for rent by owner and Baker City United States condo rentals.
Jefferson vacation rentals, Jefferson holiday rentals, rental home in Jefferson Virginia, and bed and breakfast rentals in Jefferson Virginia
Identify, look up, and invent apartment rentals in Malheur and bed and breakfast rentals Malheur.
Discover, observe, and recognize Gleneden Beach United States houses for rent, Gleneden Beach United States holiday rentals, and Gleneden Beach apartment rentals.
Junction City Oregon memorandums could root for, assist, aid, and plug your scrutiny.
Recognize and uncover vacation homes in Saint Helens and homes for rent in Saint Helens United States.
Join our beachfront classified ads, secluded indexes, and penthouse classifieds mailing list for for rent by owner homes in Junction City and Junction City Oregon vacation homes.
The Junction City Oregon listed properties specified and set down on our online website, FRBO.com embrace mountain home and oceanfront bungalow.
Learn, discover, and explore apartments for rent in Coos Oregon, holiday rentals Coos Oregon, and homes for rent by owner in Coos Oregon.
You can conceive and conceive holiday rentals and apartments for rent Junction City.
|
|
