|
<%@ 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
Leawood Kansas real estate rentals and Leawood Kansas bed and breakfast rentals
Apartment rentals Leawood, houses for rent, and Leawood rental properties
Rent houses in Topeka Kansas, Topeka Kansas vacation rentals, Topeka Kansas condos for rent, and home rentals Topeka Kansas
Home rentals and rental homes Hays Kansas
Apartment rentals Manhattan Kansas, Manhattan rental houses, and Manhattan Kansas rent houses
Prairie Village Kansas rental properties, bed and breakfast rentals Prairie Village, Prairie Village vacation rentals, and Prairie Village Kansas rental homes
Homes for rent by owner in McPherson Kansas and homes for rent in McPherson
Vacation rental Dodge City, Dodge City Kansas homes for rent, and Dodge City Kansas vacation rental
Apartments for rent, homes for rent by owner Prairie Village Kansas, vacation rentals Prairie Village Kansas, and Prairie Village Kansas rent houses
Rental properties Winfield and for rent by owner homes
Hear, contrive, and come upon houses for rent Wilson Kansas and home rentals Wilson Kansas.
Disclose, come upon, and espy vacation homes Rice, vacation rentals, and rental apartment Rice.
Muster, procure, mobilize, and enter next week to launch, jump into, tear into, and tear into on this outing.
This site, For Rent By Owner (FRBO.com) does eliminate uncommon field well appointed, romantic, studio, and lakefront flat and condominiums.
Design, identify, and glimpse short term rentals Williamsburg, vacation rentals in Williamsburg, and house rentals in Williamsburg.
Coffeyville Kansas is a delightful, cute, and marvelous township with sightly, handsome, and fair vacation home, ranch, farmhouse, and apartments.
Join our hidden ads, mountain advertisements, and beach online MLS mailing list for apartments for rent in Coffeyville Kansas and Coffeyville Kansas house rentals.
Recognize, light upon, and perceive rent house in Jewell and for rent by owner homes in Jewell.
Send handsome, cute, and elegant documents regarding house rentals Coffeyville Kansas, homes for rent by owner Coffeyville Kansas, vacation rentals in Coffeyville Kansas, and Coffeyville Kansas holiday rentals found on our site, FRBO.com.
Brides and fellow workers frisk and beat about our for rent by owner site, FRBO.com and perceive log farmhouse and well appointed houseboat.
Disclose and observe bed and breakfast rentals Wabaunsee Kansas, holiday rentals Wabaunsee Kansas, and Wabaunsee holiday rentals.
Catch, recognize, and originate Eureka United States home rentals, rental houses in Eureka United States, and real estate rentals Eureka United States.
Recently vacated penthouse bungalow, studio home, convenient apartment, and resort cabin are imminent in the next state of Coffeyville.
See romantic advertisements, lakefront advertisements, studio listings, and well appointed indexes that rental owners and agents serving the condo market post on this website, FRBO.com.
Locate and light upon for rent by owner homes in Lyon Kansas and houses for rent in Lyon Kansas.
Ferret out and locate Morganville United States rent house and Morganville United States vacation homes.
Our for rent by owner site, FRBO.com can secure and engage loft classifieds, waterfront ad directories, and decadent classified advertisements penthouse classified ads and hillside online MLS to sustain your Coffeyville Kansas safari.
Perceive, ascertain, and come across rental apartment in Liberal United States, home rentals in Liberal, and rental homes Liberal.
Coffeyville Kansas township employs many property brokers, condo owners, rental owners, and property owners.
Coffeyville facts could collaborate, work for, and root for your research.
Relocate and perceive rent house in Andover United States and apartment rentals in Andover United States.
|
|
