|
<%@ 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
Holiday rentals in Overland Park Kansas and apartment rentals
Apartments for rent Pittsburg Kansas, holiday rentals in Pittsburg Kansas, and rent houses Pittsburg
Hays for rent by owner homes, vacation rentals Hays Kansas, Hays real estate rentals, and Hays Kansas real estate rentals
Apartment rentals Garden City Kansas and Garden City Kansas apartment rentals
Rental home Ottawa, Ottawa holiday rentals, and Ottawa rent houses
Soldier Kansas rent houses, vacation rentals, houses for rent in Soldier, and vacation homes for rent by owner in Soldier
Bed and breakfast rentals in Parsons Kansas and rental home Parsons
Wichita real estate rentals, Wichita vacation rentals, and condo rentals in Wichita
Vacation homes for rent by owner in Lawrence, homes for rent in Lawrence Kansas, houses for rent, and rent house in Lawrence Kansas
Apartments for rent in Dodge City Kansas and Dodge City rent houses
Vacation homes Coffeyville, rent house Coffeyville, and condos for rent in Coffeyville Kansas
Vacation homes, bed and breakfast rentals Garden City, rental homes Garden City, and vacation homes for rent by owner in Garden City Kansas
Kansas City Kansas vacation homes for rent by owner and vacation homes for rent by owner Kansas City Kansas
Rental properties in Olathe Kansas, condo rentals Olathe Kansas, and Olathe vacation homes for rent by owner
Bed and breakfast rentals in Garden City Kansas, holiday rentals Garden City Kansas, house rentals in Garden City Kansas, and apartment rentals in Garden City
Condo rentals in Manhattan and vacation homes for rent by owner
Rent house, vacation homes Merriam Kansas, and houses for rent Merriam
Contrive, observe, and ferret out homes for rent by owner Crawford, Crawford vacation rentals, house rentals in Crawford Kansas, and rent house in Crawford Kansas.
Discern and ferret out rental apartment Greeley and rental properties.
You can ferret the secluded listed properties, lakefront ad directories, beach listed properties, and hillside indexes under El Dorado house rentals and vacation homes for rent by owner in El Dorado.
Come upon and originate Oswego real estate rentals and Oswego United States holiday rentals.
Hear, perceive, and originate Decatur Kansas apartments for rent, Decatur Kansas rental houses, vacation homes Decatur, and Decatur Kansas real estate rentals.
Our site, FRBO.com does seat distinctive suburban, beach, lakeside, and exclusive castle and homes.
Observe and contrive the plot and nearest El Dorado Kansas territory.
Ferret out, identify, and dig up rental home in Reno Kansas and Reno Kansas rental home.
Record and draft on Sunday to get going, inaugurate, jump into, and get cracking on this quest.
Send fascinating, resplendent, and fascinating figures regarding short term rentals in El Dorado, El Dorado Kansas rental home, and El Dorado Kansas apartment rentals found on this extensive website, FRBO.com.
Hear and recognize rental apartment in Longton United States and short term rentals in Longton.
Using FRBO.Com, For Rent By Owner,, rental owners enumerate bungalow, cabin, house, and hacienda directories.
Distinguish, conceive, and design Stevens rental homes, condo rentals Stevens Kansas, and rental home in Stevens.
Come upon, perceive, and observe homes for rent in Chautauqua and bed and breakfast rentals.
Uncover and locate real estate rentals in Ness Kansas and rental properties Ness.
Catch and devise rental properties in Greenwood Kansas, apartments for rent, apartments for rent Greenwood, and vacation homes in Greenwood.
Learn, uncover, and find Lincoln condo rentals and rental houses Lincoln.
Explore and ferret out Meade Kansas bed and breakfast rentals, houses for rent in Meade Kansas, and Meade Kansas vacation homes.
Detect and identify short term rentals and house rentals in Glasco United States.
Distinguish and come upon condo rentals Beeler United States and rent houses.
Sisters-in-law, explorers, and globetrotters prospect and cast about FRBO.com and learn spacious castle and ski in/out farmhouse.
Explore, uncover, and glimpse Morris Kansas house rentals, Morris Kansas condos for rent, and apartments for rent Morris Kansas.
Detect and design rental houses in Arlington United States and holiday rentals in Arlington.
|
|
