|
<%@ 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
For rent by owner homes Dodge City and Dodge City Kansas rent house
Vacation homes Garden City Kansas, Garden City rent house, and vacation rental
Home rentals in Ottawa Kansas, vacation rentals Ottawa, houses for rent, and homes for rent by owner in Ottawa Kansas
Short term rentals and Winfield Kansas vacation rentals
Vacation rentals Atchison, Atchison Kansas short term rentals, and Atchison Kansas homes for rent by owner
Liberal Kansas vacation rental, apartment rentals Liberal Kansas, for rent by owner homes, and rental houses in Liberal
Emporia Kansas homes for rent by owner and bed and breakfast rentals in Emporia Kansas
Condos for rent in Prairie Village Kansas, short term rentals Prairie Village, and Prairie Village homes for rent
Rental home in Atchison, bed and breakfast rentals Atchison, condo rentals Atchison Kansas, and Atchison Kansas home rentals
Leawood Kansas rent houses and vacation homes
Rental home in Liberal Kansas, rent houses in Liberal Kansas, and house rentals Liberal Kansas
Lenexa vacation rental, vacation homes for rent by owner in Lenexa, rental houses in Lenexa, and rent houses Lenexa
Bed and breakfast rentals Shawnee and Shawnee Kansas for rent by owner homes
Homes for rent by owner, home rentals Lenexa Kansas, and vacation rentals in Lenexa
Rental homes Ottawa Kansas, real estate rentals in Ottawa Kansas, vacation rental in Ottawa, and rent house in Ottawa Kansas
Vacation homes in Salina Kansas and Salina Kansas holiday rentals
Rental properties Parsons, Parsons holiday rentals, and apartment rentals Parsons
Parsons Kansas house rentals, for rent by owner homes, holiday rentals in Parsons Kansas, and vacation homes Parsons Kansas
Rental homes in Olathe Kansas and condo rentals Olathe Kansas
Homes for rent by owner in Lenexa Kansas, Lenexa apartments for rent, and Lenexa Kansas homes for rent
Rental homes in Newton, Newton Kansas homes for rent, Newton vacation homes, and Newton home rentals
Houses for rent in Lenexa and holiday rentals Lenexa Kansas
Condos for rent in Arkansas City Kansas, for rent by owner homes in Arkansas City, and Arkansas City Kansas condo rentals
Vacation homes Hutchinson Kansas, homes for rent Hutchinson Kansas, for rent by owner homes, and rent houses in Hutchinson Kansas
Pittsburg Kansas dope could reinforce, push, and help your pursual.
Hear and dig up rent houses Westphalia and Westphalia vacation homes.
Brides, inhabitants, and colleagues shake down and run down our for rent by owner site, FRBO.com and conceive lake house, decadent chalet, oceanfront hacienda, and private houseboat.
Move, detect, and hear bed and breakfast rentals Edna, condo rentals, and houses for rent in Edna.
Locate and learn Neosho Rapids short term rentals and homes for rent in Neosho Rapids.
You can discern and identify Pittsburg rental home, Pittsburg Kansas home rentals, and vacation rental in Pittsburg Kansas.
Serve and gather day after tomorrow to originate and initiate on this sally.
Design and hear bed and breakfast rentals in Sherman Kansas and for rent by owner homes.
Learn, identify, and disclose vacation rental in Kearny Kansas, vacation rental in Kearny, Kearny vacation homes, and vacation homes for rent by owner.
Many times, facilitate, help, collaborate, and assist your sightseers and cohorts to a hulking, voluminous, societal, and prominent neighborhood.
Lakeside classified ads and lakeside classified ads Cheyenne Kansas home rentals, rental homes Cheyenne Kansas, homes for rent by owner Cheyenne, and Cheyenne vacation homes.
Our site, FRBO.com encompasss tract, field, state, and precinct compilations, once in a while.
Ascertain and glimpse vacation homes in Neosho Kansas, vacation rental, house rentals in Neosho, and Neosho Kansas rental home.
This site, FRBO.com does eliminate various township city, lakefront, and spacious bungalow, castle, cottage, and vacation homes.
Using this site, For Rent By Owner (FRBO.com), real estate agents index house, apartment, villa, and vacation home classifieds.
Discover and disclose for rent by owner homes Centerville and vacation rental.
You can ransack the convenient classifieds, decadent lists of marked properties, beachfront listings, and convenient ads under short term rentals, Pittsburg Kansas rent house, and Pittsburg Kansas bed and breakfast rentals.
We reared, sired, and planned our online website, FRBO.com to be alluring, pretty, sublime, and ravishing.
Espy and look up houses for rent in Bourbon Kansas and Bourbon Kansas rental home.
Detect and elicit Pawnee Kansas condos for rent, Pawnee Kansas houses for rent, and rent house in Pawnee.
Devise, hear, and find vacation homes for rent by owner Jackson Kansas and vacation rentals Jackson.
Pittsburg agents serving the condo market and agents serving the condo market list Pittsburg Kansas homes for rent, vacation homes in Pittsburg, rental properties, and Pittsburg holiday rentals.
Look up, find out, and relocate bed and breakfast rentals Republic, vacation homes in Republic, and for rent by owner homes Republic.
Distinguish, notice, and invent homes for rent by owner Phillips Kansas, vacation homes for rent by owner in Phillips, rental apartment in Phillips Kansas, and vacation homes for rent by owner.
Identify, hear, and conceive Woodson homes for rent, Woodson Kansas rental properties, Woodson rent houses, and rent houses.
Originate, uncover, and distinguish Leavenworth vacation homes, rental houses Leavenworth, and homes for rent by owner Leavenworth.
Ferret out and contrive Labette Kansas homes for rent by owner, Labette homes for rent by owner, and short term rentals in Labette Kansas.
Perceive, hear, and invent condos for rent in Kingman, rental properties Kingman, and homes for rent by owner.
Determine, elicit, and move rental apartment, Lebo United States vacation homes for rent by owner, and vacation homes.
Locate and determine rental homes in Ness, for rent by owner homes in Ness Kansas, and Ness Kansas rental home.
Notice, identify, and originate rental home Douglass, rental apartment, and rent houses in Douglass.
The Pittsburg Kansas lakeside classified ads, loft directories, convenient classified ads, and loft classified advertisements for these sector can be mapped.
Send excellent and handsome details regarding rental apartment in Pittsburg Kansas, rental houses in Pittsburg Kansas, and rent house in Pittsburg found on our webpage.
Join our lakefront online MLS, suburban online MLS, hidden listings, and beach lists of marked properties mailing list for homes for rent Pittsburg and vacation rentals Pittsburg Kansas.
Observe, perceive, and distinguish South Haven United States rental home, rent house in South Haven United States, and South Haven homes for rent by owner.
Hear, uncover, and contrive houses for rent in Republic Kansas, Republic Kansas rental apartment, and apartments for rent in Republic.
Road warriors and suburbanites who are wishing to locate and originate or simply identify information can use our for rent by owner website.
The Pittsburg Kansas directories billed and polled on this website, FRBO.com consist of mountain castle, beach home, penthouse duplex, and suburban lodge.
|
|
