|
<%@ 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 McPherson Kansas and vacation rental in McPherson
Shawnee Kansas rent houses, Shawnee Kansas rental home, and rental properties Shawnee Kansas
Rental home in Garden City, vacation rental, vacation rentals in Garden City Kansas, and for rent by owner homes in Garden City Kansas
Rent houses in Olathe Kansas and rent house Olathe
Rental homes in Ottawa Kansas, rental houses in Ottawa Kansas, and Ottawa apartments for rent
Soldier Kansas apartments for rent, holiday rentals in Soldier, bed and breakfast rentals in Soldier Kansas, and Soldier Kansas rent house
Real estate rentals Overland Park Kansas and rent houses in Overland Park
Rental homes, houses for rent in Lawrence, and home rentals Lawrence Kansas
Rent house in Arkansas City Kansas, Arkansas City apartment rentals, rent houses in Arkansas City Kansas, and condo rentals in Arkansas City
Ottawa Kansas condos for rent and Ottawa holiday rentals
House rentals in Manhattan Kansas, rent house Manhattan Kansas, and rental apartment in Manhattan Kansas
Arkansas City Kansas home rentals, short term rentals, homes for rent in Arkansas City, and homes for rent Arkansas City
Home rentals Kansas City Kansas and homes for rent in Kansas City
Soldier Kansas real estate rentals, apartments for rent in Soldier Kansas, and Soldier Kansas vacation rental
Rental homes, condo rentals, vacation rental in Overland Park Kansas, and rental homes Overland Park
Leavenworth Kansas rental properties and holiday rentals Leavenworth Kansas
Determine, uncover, and disclose Westmoreland United States houses for rent, Westmoreland United States rental houses, and home rentals in Westmoreland United States.
Conceive and learn vacation rentals in Holton and homes for rent in Holton United States.
You can cast about the beach listings, penthouse indexes, log online MLS, and mountain listed properties under short term rentals, McPherson home rentals, and real estate rentals in McPherson Kansas.
McPherson info could abet, root for, support, and stump your inquiry.
See studio classifieds, decadent classifieds, secluded ad directories, and hidden indexes that real estate agents and condo owners post on our site, FRBO.com.
Recognize and locate holiday rentals in Norton Kansas and homes for rent by owner Norton.
Join our exotic classified ads, lake classifieds, beachfront listed properties, and city advertisements mailing list for home rentals in McPherson Kansas, for rent by owner homes McPherson, and vacation homes McPherson Kansas.
FRBO.com embodys city, sector, and field reports, habitually.
Using our online website, FRBO.com, condo owners note cabin, condominium, vacation home, and cabin ad directories.
McPherson brokers leasing foreclosures, property agents, and real estate investors list rent house in McPherson Kansas and holiday rentals in McPherson Kansas.
Our for rent by owner site, FRBO.com can admit, assign, and serve beach directories, waterfront advertisements, rustic online MLS, and studio indexes suburban ad directories and city ads to help your McPherson hike.
Elicit, invent, and move rental houses Stafford and Stafford Kansas condo rentals.
Conceive, ascertain, and originate for rent by owner homes Norton and Norton rental apartment.
We initiated, performed, and sired FRBO.Com, For Rent By Owner, to be handsome, pulchritudinous, and lovely.
|
|
