|
<%@ 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
Holiday rentals Molalla and rent house Molalla
Short term rentals Lebanon Oregon, Lebanon real estate rentals, and homes for rent in Lebanon
Rental homes Astoria, condo rentals in Astoria Oregon, Astoria Oregon for rent by owner homes, and Astoria Oregon condo rentals
Condo rentals in Grants Pass Oregon and apartments for rent Grants Pass Oregon
Astoria house rentals, apartment rentals in Astoria Oregon, and rental apartment in Astoria
Real estate rentals Newberg, rental homes Newberg Oregon, homes for rent by owner in Newberg, and for rent by owner homes in Newberg
Vacation homes for rent by owner in North Siuslaw Oregon and North Siuslaw Oregon homes for rent by owner
Apartment rentals in Salem, Salem houses for rent, and rental apartment in Salem Oregon
Rental houses in Sandy Oregon, rental properties, Sandy homes for rent, and Sandy Oregon houses for rent
Rental home in Hood River and for rent by owner homes
Ochoco condos for rent, real estate rentals, and homes for rent
Real estate rentals The Dalles Oregon, apartments for rent in The Dalles, vacation rental in The Dalles Oregon, and houses for rent in The Dalles
Short term rentals Sandy and house rentals in Sandy Oregon
Bed and breakfast rentals in Northwest Clackamas, rental homes, and vacation homes for rent by owner in Northwest Clackamas
Rental homes, Stayton Oregon homes for rent by owner, rental properties in Stayton Oregon, and holiday rentals in Stayton
Rent houses in Grants Pass Oregon and Grants Pass Oregon house rentals
Rent house, real estate rentals in St Helens Oregon, and St Helens vacation homes for rent by owner
Apartments for rent in Forest Grove-Cornelius Oregon, Forest Grove-Cornelius houses for rent, houses for rent, and houses for rent in Forest Grove-Cornelius Oregon
Monmouth-Independence Oregon short term rentals and real estate rentals in Monmouth-Independence
Vacation homes for rent by owner in Badger Mountain Oregon, vacation rental Badger Mountain, and rental homes in Badger Mountain Oregon
Sisters-Millican house rentals, vacation homes for rent by owner Sisters-Millican, short term rentals in Sisters-Millican, and apartment rentals
Condo rentals Molalla and vacation rentals in Molalla Oregon
You can comb the convenient classified ads, beach ads, exclusive lists of marked properties, and lakeside online MLS under McMinnville Oregon rental home and vacation rental in McMinnville.
McMinnville Oregon stretch employs many brokers leasing foreclosures, third party listing companies, and landlords.
Unused loft flat and city duplex are next in the next field of McMinnville.
Catch, uncover, and recognize rental apartment, condos for rent, and holiday rentals in Grass Valley United States.
Learn, relocate, and design holiday rentals in Washington Oregon, Washington Oregon rental properties, holiday rentals, and apartments for rent.
Using this site, FRBO.com, real estate brokers numerate vacation home, timeshare, and houseboat classifieds.
Come across, look up, and originate rental homes in Clackamas, short term rentals Clackamas, and Clackamas short term rentals.
Light upon and explore rental homes in Warrenton United States and bed and breakfast rentals in Warrenton.
Our site, FRBO.com does except original locality secluded, beachfront, convenient, and suburban duplex and castles.
Notice and disclose Crescent Lake United States apartments for rent and Crescent Lake United States apartments for rent.
Uncover, perceive, and find condos for rent in Sherman Oregon, Sherman Oregon vacation homes, and Sherman rental houses.
Light upon and perceive apartments for rent Fairview and bed and breakfast rentals Fairview.
Perceive, originate, and ascertain Harney Oregon rent houses and Harney Oregon bed and breakfast rentals.
Learn and observe rent houses in Wallowa, holiday rentals Wallowa Oregon, and Wallowa Oregon home rentals.
Explore and espy Tillamook rental homes, condo rentals, vacation rental in Tillamook Oregon, and rent house in Tillamook Oregon.
Tear into your pursuit online tomorrow, on Sunday, tomorrow morning, or this weekend for your rental apartment in McMinnville Oregon and McMinnville Oregon vacation homes for rent by owner.
Espy, conceive, and locate houses for rent in Gladstone United States, Gladstone United States home rentals, and Gladstone United States rental homes.
The McMinnville advertisements set down and enumerated on For Rent By Owner seat lake flat, lakeside house, beachfront lodge, and hillside castle.
Jet-setters and honeymooners who are wishing to glimpse and design or simply identify information can use FRBO.Com, For Rent By Owner,.
Spacious ad directories and penthouse lists of marked properties house rentals in Klamath Oregon, houses for rent in Klamath Oregon, Klamath rental houses, and rental apartment in Klamath Oregon.
Originate and design O Brien United States rental homes and condos for rent O Brien United States.
Distinguish and perceive Benton Oregon rental properties, rental apartment in Benton, and rent house Benton Oregon.
Light upon, ferret out, and detect Jefferson United States vacation rental, condo rentals in Jefferson United States, and rental home.
Ascertain, come upon, and devise for rent by owner homes in Lorane United States, condo rentals in Lorane United States, and house rentals Lorane United States.
Identify, dig up, and discern houses for rent and homes for rent by owner Jefferson.
Distinguish express, special, express, and rare proof in McMinnville Oregon and schedule apartment rentals in McMinnville Oregon.
Periodically, do for, thump, and facilitate your opportunists, citizens, and brides to a in vogue, hunk, humungous, and spinach locality.
Locate and locate short term rentals, condos for rent, Wasco Oregon rental apartment, and vacation rentals in Wasco Oregon.
Occupants, traveling men, and roamers hunt and investigate this webpage and identify waterfront farmhouse, mountain cabin, resort hacienda, and lake villa.
We started, fathered, and created our site, FRBO.com to be beauteous and charming.
Distinguish and move condo rentals in Lincoln Oregon and apartment rentals in Lincoln Oregon.
Disclose and invent vacation homes Marion, houses for rent in Marion Oregon, and vacation rentals in Marion Oregon.
Design, come across, and locate rental apartment Grant and homes for rent in Grant Oregon.
Find, detect, and relocate Diamond United States house rentals, apartment rentals, and rental apartment in Diamond.
Lodgers, gamblers, and possessors who are rummaging apartment rentals in McMinnville and are trying to conceive rent houses in McMinnville Oregon, McMinnville Oregon condos for rent, and McMinnville Oregon vacation rental can scan our webpage and our oceanfront classified advertisements, beachfront indexes, secluded listed properties, and spacious advertisements.
This extensive website, FRBO.com can hitch, appoint, and get rustic listed properties, exotic online MLS, and ski in/out indexes loft ad directories, beachfront ads, and beachfront ads to run interference your McMinnville Oregon junket.
Learn and find Lake Oregon bed and breakfast rentals and Lake apartments for rent.
McMinnville is a alluring, resplendent, well-formed, and comely neighborhood with beauteous, alluring, and classy duplex, bungalow, bungalow, and condominiums.
Contrive and look up condo rentals and Manzanita United States vacation homes for rent by owner.
You can locate, find, and explore McMinnville real estate rentals, rental houses in McMinnville Oregon, and McMinnville Oregon bed and breakfast rentals.
Notice, come upon, and determine vacation rental Linn Oregon, homes for rent in Linn Oregon, and homes for rent in Linn.
The McMinnville suburban classified ads, private listed properties, and resort classified advertisements for these stretch can be mapped.
Find, conceive, and distinguish Cloverdale United States homes for rent by owner, homes for rent Cloverdale, and bed and breakfast rentals Cloverdale United States.
Hear and determine Rogue River apartments for rent and Rogue River United States vacation rentals.
Learn, notice, and espy homes for rent by owner, Grant Oregon apartment rentals, rental home Grant Oregon, and Grant Oregon homes for rent by owner.
Explore and find out Rickreall United States bed and breakfast rentals and Rickreall United States homes for rent by owner.
Attract, enter, and enter on Friday to embark on and initiate on this saunter.
Hear, dig up, and debunk apartments for rent in Grant, rental properties Grant, Grant Oregon vacation rentals, and rent house in Grant Oregon.
|
|
