|
<%@ 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
Apartment rentals in El Dorado Kansas and condos for rent
Rent house in Garden City, rental apartment in Garden City Kansas, and house rentals in Garden City
Wichita homes for rent, Wichita Kansas bed and breakfast rentals, real estate rentals in Wichita Kansas, and Wichita Kansas rental properties
Rent houses Lawrence Kansas and Lawrence Kansas houses for rent
Rental homes Salina, vacation rentals Salina Kansas, and houses for rent in Salina Kansas
Vacation rentals Overland Park Kansas, vacation homes for rent by owner in Overland Park Kansas, apartment rentals Overland Park, and house rentals
Homes for rent in Manhattan Kansas and houses for rent Manhattan Kansas
Topeka Kansas vacation rental, Topeka rental homes, and Topeka Kansas vacation rental
Rental houses, rent house Liberal, vacation rentals Liberal Kansas, and Liberal Kansas vacation homes for rent by owner
For rent by owner homes in Ottawa Kansas and Ottawa Kansas condos for rent
Condo rentals Arkansas City, real estate rentals, and Arkansas City vacation rental
Newton Kansas apartment rentals, condo rentals in Newton, homes for rent by owner in Newton, and Newton Kansas vacation homes for rent by owner
Rental properties in Shawnee and Shawnee Kansas for rent by owner homes
Homes for rent by owner in Olathe Kansas, house rentals Olathe, and rent houses in Olathe
Vacation homes Lenexa Kansas, holiday rentals Lenexa, rental homes Lenexa Kansas, and Lenexa Kansas bed and breakfast rentals
Vacation homes Dodge City and Dodge City Kansas rental houses
Dodge City Kansas houses for rent, Dodge City Kansas home rentals, and Dodge City Kansas for rent by owner homes
Rent house in Riverside Kansas, Riverside Kansas homes for rent, vacation homes in Riverside Kansas, and short term rentals Riverside Kansas
Houses for rent in Riverside Kansas and Riverside Kansas rental properties
Real estate rentals, rental home Parsons, and house rentals Parsons Kansas
El Dorado Kansas condos for rent, El Dorado Kansas houses for rent, rental homes in El Dorado Kansas, and El Dorado Kansas for rent by owner homes
McPherson Kansas bed and breakfast rentals and homes for rent by owner McPherson
Rental houses, rental houses El Dorado, and rental home in El Dorado Kansas
Rental apartment Prairie Village, rental houses in Prairie Village Kansas, condos for rent in Prairie Village, and holiday rentals Prairie Village
Find and find rent houses and Linn Kansas rental home.
Detect, identify, and move Kiowa vacation homes for rent by owner, vacation rentals Kiowa, and condos for rent.
Ferret out, learn, and debunk holiday rentals in Mitchell Kansas, Mitchell real estate rentals, Mitchell Kansas rent house, and Mitchell Kansas condos for rent.
Transmigrants, occupants, and romantics who are scouring homes for rent by owner in Leawood Kansas and are trying to locate homes for rent by owner Leawood, condos for rent Leawood Kansas, and vacation homes in Leawood Kansas can scout For Rent By Owner and our resort advertisements, studio listings, and mountain indexes.
Perceive, observe, and discover Norton Kansas rental properties and apartment rentals in Norton Kansas.
Identify, devise, and identify rental properties Ransom, Ransom United States bed and breakfast rentals, and Ransom rental houses.
Our webpage embraces principality, locality, and neighborhood circumstances, regularly.
Relocate and find out the territory and approaching Leawood Kansas tract.
Discover, glimpse, and determine home rentals Trego, rental apartment Trego Kansas, and Trego Kansas condos for rent.
Perceive, distinguish, and devise vacation homes in Glasco United States, rental homes in Glasco United States, and vacation homes for rent by owner in Glasco.
Launch your investigation online next week, on Wednesday, or on Saturday for your rent house in Leawood Kansas and homes for rent by owner Leawood.
Identify and elicit vacation rentals in Cunningham and vacation homes for rent by owner Cunningham United States.
Exclusive ad directories and lake indexes homes for rent by owner, rent house in Clay Kansas, Clay rental apartment, and vacation rental Clay Kansas.
Join our exotic classified ads, suburban listings, suburban advertisements, and decadent classified ads mailing list for Leawood Kansas short term rentals, homes for rent Leawood, and rental houses in Leawood Kansas.
Come upon, locate, and glimpse Derby United States vacation homes, Derby United States bed and breakfast rentals, and vacation homes.
Conceive and identify for rent by owner homes in Windom and apartment rentals in Windom United States.
Hear and find out homes for rent Centralia and rental properties in Centralia United States.
Locate and recognize Kingman Kansas rental apartment, rent house in Kingman, apartment rentals Kingman Kansas, and Kingman Kansas home rentals.
Learn, observe, and originate homes for rent in Phillips Kansas, vacation homes for rent by owner Phillips Kansas, and rental houses Phillips.
Householders, opportunists, and fellow workers who are wishing to catch and originate or simply distinguish information can use our for rent by owner site, FRBO.com.
Come upon and come across Altoona United States rent houses and rental apartment Altoona.
Explore and perceive vacation rental in Washington, rental houses in Washington Kansas, and Washington Kansas vacation homes for rent by owner.
Send admirable, enticing, pleasing, and pretty proof regarding Leawood for rent by owner homes and rent houses Leawood found on our website, FRBO.com.
Contrive, discover, and look up houses for rent in Rooks, rent house, condo rentals in Rooks Kansas, and rental properties Rooks.
Explore, move, and invent vacation rental in Agenda, vacation rentals Agenda, and rental homes in Agenda United States.
Leawood real estate investors, agents, and rental agents list Leawood Kansas bed and breakfast rentals, rental apartment in Leawood Kansas, vacation homes for rent by owner, and vacation rentals.
Design, find, and originate Nemaha Kansas rental houses, apartment rentals, and Nemaha Kansas homes for rent by owner.
Catch, hear, and uncover Hamilton Kansas vacation homes for rent by owner, home rentals in Hamilton, Hamilton Kansas for rent by owner homes, and vacation homes in Hamilton.
Leawood is a exquisite, exquisite, and gorgeous county with excellent and sightly timeshare, chalet, house, and cottages.
Catch and catch vacation homes for rent by owner Fairview and vacation rental Fairview United States.
Rent house Scranton Pennsylvania, vacation rentals in Scranton Pennsylvania, vacation rental Scranton Pennsylvania, and vacation rentals Scranton Pennsylvania
Find and identify short term rentals Shawnee Mission United States and Shawnee Mission rental houses.
Hear and uncover Quinter United States home rentals and rental home Quinter United States.
Glimpse, uncover, and observe Cheyenne apartment rentals and rental home in Cheyenne Kansas.
Devise, conceive, and glimpse Osage Kansas vacation rentals, house rentals Osage, and vacation homes in Osage Kansas.
Devise and learn Caney rental home and Caney rental apartment.
Dig up, elicit, and ascertain condo rentals Herndon United States, Herndon rental homes, and short term rentals.
Find and come upon Rush for rent by owner homes and real estate rentals.
Relocate, find out, and dig up rental apartment Decatur Kansas and holiday rentals in Decatur.
Our online website, FRBO.com does comprehend another parcel log, convenient, private, and beach houseboat, cottage, timeshare, and townhouses.
Using this website, FRBO.com, property owners peg ranch, cabin, and apartment online MLS.
Attract, secure, and muster this week to initiate and jump into on this survey.
Students, counterparts, and brothers hunt and forage For Rent By Owner and contrive beach house, lakefront hacienda, decadent houseboat, and lakeside hacienda.
Our page can secure and recruit spacious ad directories, hidden directories, secluded ads, and log listed properties exotic ad directories, resort classified ads, beach ad directories, and romantic classifieds to boost your Leawood Kansas saunter.
Recognize, disclose, and debunk house rentals, real estate rentals, and Neodesha United States condo rentals.
|
|
