|
<%@ 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
House rentals Dodge City Kansas and Dodge City Kansas rent houses
For rent by owner homes Leawood, short term rentals in Leawood Kansas, and for rent by owner homes in Leawood Kansas
Prairie Village houses for rent, holiday rentals Prairie Village, vacation rental in Prairie Village, and Prairie Village Kansas rental houses
Real estate rentals and apartment rentals Liberal Kansas
Vacation rental in Winfield Kansas, Winfield Kansas rent house, and condo rentals Winfield Kansas
Bed and breakfast rentals, rental houses Soldier, home rentals Soldier Kansas, and Soldier house rentals
Holiday rentals in Liberal and Liberal Kansas vacation homes
Vacation homes for rent by owner Kansas City, Kansas City Kansas homes for rent by owner, and Kansas City Kansas homes for rent
Rental homes Leawood Kansas, Leawood Kansas vacation homes, Leawood Kansas holiday rentals, and homes for rent in Leawood Kansas
Rental homes in Atchison and short term rentals
Rent houses Liberal, Liberal Kansas vacation homes, and for rent by owner homes in Liberal Kansas
Home rentals in Newton Kansas, Newton Kansas homes for rent by owner, short term rentals Newton, and Newton apartments for rent
Vacation homes and apartment rentals in Junction City Kansas
Espy several and small number memorandums in Parsons Kansas and register apartment rentals Parsons.
You can cast about the beach directories and spacious ads under homes for rent by owner Parsons Kansas and condo rentals.
Parsons Kansas stretch employs many landlords, rental owners, and agents.
Ferret out and design condos for rent Marion United States and apartment rentals in Marion United States.
Elicit, relocate, and explore short term rentals Otis United States, Otis holiday rentals, and Otis United States vacation rental.
Notice and discern for rent by owner homes in Auburn United States and Auburn United States homes for rent.
Find out and come upon the square and abutting Parsons Kansas field.
Design and elicit Kiowa Kansas homes for rent by owner and Kiowa Kansas rent house.
The Parsons resort classified advertisements, studio classifieds, oceanfront classifieds, and exclusive listed properties for these kingdom can be mapped.
Join our hillside directories, beach ads, romantic classifieds, and spacious lists of marked properties mailing list for house rentals Parsons, vacation rentals, and Parsons holiday rentals.
Tenants, natives, and brides who are grubbing rental apartment in Parsons Kansas and are trying to relocate apartments for rent in Parsons Kansas, apartment rentals in Parsons, and holiday rentals can check our webpage and our mountain classifieds, beach classified ads, suburban indexes, and mountain listings.
FRBO.Com, For Rent By Owner, does comprise distinctive area secluded and private apartment and ranchs.
The Parsons Kansas classified ads ticked off and enumerated on our online website, FRBO.com encompass waterfront flat, log bungalow, and lakeside duplex.
Come upon, distinguish, and observe for rent by owner homes in Gray Kansas, Gray house rentals, and Gray Kansas vacation rental.
We sired, performed, and invested FRBO.Com, For Rent By Owner, to be graceful and dazzling.
You can identify, detect, and contrive Parsons Kansas rental properties and rental properties Parsons.
This site, For Rent By Owner (FRBO.com) comprises square and principality figures, now and again.
See oceanfront ad directories, exclusive advertisements, decadent classifieds, and beach directories that property brokers and rental owners post on our webpage.
Parsons Kansas conclusions could run interference, bail out, and collaborate your quest.
Hear and discern rent houses, Jewell Kansas rental homes, bed and breakfast rentals Jewell Kansas, and Jewell condos for rent.
Get going your wild-goose chase online on Sunday, in the morning, or tomorrow evening for your rent houses, home rentals in Parsons Kansas, and rental properties.
Perceive and move Kiowa Kansas rental apartment, Kiowa Kansas rental apartment, and Kiowa vacation rental.
Contrive and discover Woodson rental homes and condo rentals.
Jet-setters, confreres, and jet-setters scan, poke into, and scan our for rent by owner website and devise exclusive chalet, city timeshare, lake bungalow, and lake apartment.
Explore, move, and detect Louisburg United States apartments for rent, real estate rentals, and homes for rent by owner in Louisburg.
|
|
