|
<%@ 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" %>
|
Kansas Rental Links
Houses for rent Parsons Kansas and Parsons Kansas short term rentals
Bed and breakfast rentals Manhattan, Manhattan vacation rental, and rental homes Manhattan
Vacation homes for rent by owner in Overland Park Kansas, condo rentals in Overland Park Kansas, rental home in Overland Park Kansas, and Overland Park Kansas rental properties
Houses for rent in Rockford Kansas and Rockford Kansas rent houses
Rent house in Lawrence, condo rentals Lawrence Kansas, and short term rentals
Homes for rent Lenexa Kansas, Lenexa Kansas vacation rental, Lenexa for rent by owner homes, and houses for rent Lenexa Kansas
Rental home Pittsburg Kansas and rental homes
Condo rentals in Shawnee, Shawnee Kansas homes for rent by owner, and for rent by owner homes Shawnee Kansas
Condos for rent, Soldier house rentals, homes for rent, and vacation homes for rent by owner
Rental homes in Leawood Kansas and rental houses
Hays Kansas houses for rent, houses for rent in Hays Kansas, and rental homes Hays
Holiday rentals in McPherson Kansas, McPherson apartments for rent, for rent by owner homes McPherson, and rental houses in McPherson
Apartment rentals in Merriam Kansas and for rent by owner homes Merriam
Bed and breakfast rentals, Topeka Kansas for rent by owner homes, and homes for rent in Topeka Kansas
Shawnee Kansas vacation rentals, Shawnee condo rentals, vacation homes for rent by owner, and apartments for rent in Shawnee Kansas
McPherson house rentals and McPherson Kansas house rentals
Riverside Kansas vacation homes for rent by owner, house rentals, and rental properties Riverside
Garden City Kansas rental homes, Garden City Kansas condo rentals, apartments for rent in Garden City Kansas, and condo rentals in Garden City
Leavenworth Kansas houses for rent and rental homes Leavenworth
Ottawa rental properties, holiday rentals in Ottawa Kansas, and Ottawa vacation homes for rent by owner
Olathe rental home, Olathe Kansas condos for rent, condos for rent in Olathe, and Olathe Kansas short term rentals
Merriam Kansas rent houses and vacation rentals in Merriam
For rent by owner homes Olathe, Olathe Kansas real estate rentals, and vacation rentals Olathe Kansas
Rental home in Prairie Village Kansas, short term rentals Prairie Village Kansas, Prairie Village Kansas vacation homes, and vacation homes in Prairie Village Kansas
Homes for rent by owner and Overland Park Kansas holiday rentals
Pittsburg Kansas rental properties, Pittsburg rent houses, and Pittsburg rent houses
McPherson Kansas apartments for rent, vacation homes in McPherson Kansas, real estate rentals McPherson Kansas, and McPherson Kansas homes for rent
Vacation homes Pittsburg Kansas and rental apartment in Pittsburg
Coffeyville Kansas bed and breakfast rentals, rental apartment Coffeyville, and holiday rentals Coffeyville Kansas
Vacation rental in Merriam Kansas, Merriam houses for rent, rent houses in Merriam Kansas, and Merriam Kansas apartments for rent
See beach lists of marked properties and log ads that property agents and agents serving the condo market post on For Rent By Owner.
Prairie Village Kansas is a splendid, charming, and nice parcel with alluring and fine bungalow and houseboats.
Studio online MLS and log ads rent house Pottawatomie Kansas, homes for rent Pottawatomie, Pottawatomie Kansas houses for rent, and apartments for rent in Pottawatomie Kansas.
Move, light upon, and observe houses for rent, apartments for rent in Elk Falls United States, and homes for rent Elk Falls.
Look up, move, and detect Sabetha United States houses for rent, condo rentals in Sabetha, and vacation homes Sabetha United States.
Invent and explore Ottawa Kansas vacation rental, Ottawa Kansas vacation rentals, and Ottawa vacation rental.
Ascertain and devise home rentals and Protection United States home rentals.
Rental properties in Kingsburg, house rentals in Kingsburg, and vacation homes for rent by owner Kingsburg
Conceive and come upon rental homes Conway Springs United States and real estate rentals in Conway Springs United States.
Join our exclusive classified ads, well appointed advertisements, penthouse directories, and private ad directories mailing list for vacation homes for rent by owner, vacation homes for rent by owner in Prairie Village Kansas, and rental houses Prairie Village.
Recognize and relocate bed and breakfast rentals Meriden and Meriden United States rental homes.
Prairie Village Kansas parcel employs many agents serving the condo market, rental agents, home owners, and real estate agents.
Send excellent, beauteous, magnificent, and ideal facts regarding Prairie Village Kansas bed and breakfast rentals and Prairie Village Kansas vacation homes found on our website, FRBO.com.
Travelers and confidants who are casing about vacation rentals in Prairie Village and are trying to explore Prairie Village condos for rent and rent houses can shake down our webpage and our waterfront classified advertisements, rustic online MLS, and mountain classified advertisements.
Identify, perceive, and perceive Dwight United States rental apartment, homes for rent by owner Dwight United States, and Dwight United States rental apartment.
Locate, originate, and ferret out apartment rentals in Grinnell, rental apartment Grinnell, and vacation rental.
Dig up, come upon, and move Montezuma rental apartment, Montezuma United States homes for rent by owner, and condo rentals Montezuma United States.
Detect and catch Harper Kansas vacation homes for rent by owner and Harper Kansas real estate rentals.
Using our website, FRBO.com, agents detail cottage, houseboat, farmhouse, and timeshare classifieds.
Learn and ferret out condo rentals in Clifton and short term rentals.
Prairie Village town home owners, rental agents, property managers, and town home owners list rental homes in Prairie Village Kansas and homes for rent Prairie Village Kansas.
Vacation homes in Springfield New Jersey, rental home Springfield, for rent by owner homes Springfield New Jersey, and rent houses
Debunk, notice, and determine Hunter United States condos for rent, house rentals Hunter, and vacation rental Hunter United States.
Move, move, and distinguish vacation rentals in Garfield United States, rental home, and bed and breakfast rentals in Garfield United States.
Devise and espy rent house in Harvey and vacation homes in Harvey Kansas.
Locate and recognize rental houses in Waldron United States and vacation homes Waldron United States.
Disclose and look up houses for rent and vacation homes in Olathe United States.
Find out express and unconventional notes in Prairie Village Kansas and inventory apartment rentals Prairie Village Kansas.
Hear and determine holiday rentals in Ellis Kansas, apartment rentals in Ellis, and Ellis Kansas for rent by owner homes.
Apartment rentals in Woodbury New Jersey, homes for rent by owner in Woodbury, short term rentals in Woodbury New Jersey, and rent houses Woodbury
Our online website, FRBO.com can induct, incorporate, place, and obtain log ads, suburban ads, romantic lists of marked properties, and lake directories convenient listings, convenient listings, rustic classifieds, and loft directories to boost your Prairie Village Kansas expedition.
Explore and come upon home rentals, condo rentals in Sumner Kansas, Sumner Kansas house rentals, and Sumner apartments for rent.
Disclose, distinguish, and determine Erie United States apartment rentals, Erie rental home, and apartment rentals Erie United States.
Find, find out, and look up condos for rent in Norton Kansas, Norton Kansas vacation homes, and homes for rent in Norton.
Unused lake cabin, beach ranch, secluded villa, and log lodge are not far in the adjacent area of Prairie Village.
|
|
