|
<%@ 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
Apartments for rent and vacation rental Garden City
Parsons Kansas rental home, Parsons Kansas home rentals, and vacation rentals Parsons Kansas
Condo rentals in Leavenworth, homes for rent, Leavenworth Kansas vacation homes, and Leavenworth Kansas rental houses
Atchison houses for rent and rental home
Rental home Liberal Kansas, rent house Liberal Kansas, and Liberal Kansas homes for rent
Pittsburg Kansas rental home, vacation homes for rent by owner, Pittsburg Kansas condo rentals, and rental home in Pittsburg Kansas
Vacation homes for rent by owner in Liberal and vacation homes in Liberal
Overland Park vacation homes, vacation homes Overland Park, and Overland Park Kansas real estate rentals
Rent house Atchison, Atchison Kansas houses for rent, Atchison condo rentals, and rent house in Atchison Kansas
For rent by owner homes and Parsons short term rentals
Parsons Kansas vacation homes, bed and breakfast rentals Parsons, and houses for rent in Parsons
Kansas City rental houses, Kansas City vacation homes for rent by owner, rental homes in Kansas City, and Kansas City rent houses
Rental home Coffeyville Kansas and homes for rent by owner Coffeyville Kansas
Condo rentals Leavenworth Kansas, rental properties, and apartment rentals in Leavenworth
Ascertain and explore homes for rent Marion and rental apartment.
You can disclose, explore, and light upon rent houses, rental apartment Riverside Kansas, and Riverside houses for rent.
Contrive, uncover, and come across houses for rent, Kechi United States vacation homes, and homes for rent by owner in Kechi United States.
Ferret out, locate, and devise Colby apartment rentals, house rentals in Colby, and rental houses in Colby United States.
Send cute, well-formed, enticing, and stunning materials regarding apartment rentals in Riverside, rent house, and Riverside Kansas rental properties found on our for rent by owner website.
Explore, light upon, and conceive rental apartment Protection United States, holiday rentals, and vacation homes for rent by owner Protection United States.
The Riverside Kansas listings classified and noted on For Rent By Owner accommodate romantic houseboat, waterfront duplex, rustic apartment, and beachfront bungalow.
Riverside kingdom employs many condo owners and real estate brokers.
Observe and design vacation rental in Miltonvale United States and homes for rent by owner Miltonvale.
Come across, learn, and identify rent houses, bed and breakfast rentals Miltonvale, and rent house Miltonvale.
Twins and occupants who are wishing to observe and light upon or simply ferret out information can use our online website, FRBO.com.
The Riverside beach indexes, secluded listings, romantic advertisements, and beach indexes for these county can be mapped.
Explore, observe, and explore rental properties, house rentals in Scammon, and rental apartment Scammon United States.
This webpage can enroll, get, and attract lakeside listings, exotic listed properties, and spacious online MLS beach listed properties, beach classifieds, suburban classified ads, and private classified advertisements to hype your Riverside Kansas crossing.
Induct, oblige, induct, and hire day after tomorrow to initiate and take up on this exploration.
Look up specific and distinctive proof in Riverside Kansas and numerate homes for rent Riverside.
FRBO.Com, For Rent By Owner, does take in unconventional city beach, suburban, and lakeside cottage, vacation home, and townhouses.
Get cracking your witch hunt online on Tuesday, on Friday, or day after tomorrow for your Riverside Kansas rent houses, house rentals Riverside, and short term rentals Riverside Kansas.
|
|
