|
<%@ 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
Lenexa apartment rentals and Lenexa Kansas apartment rentals
Condo rentals in Riverside Kansas, for rent by owner homes Riverside Kansas, and Riverside bed and breakfast rentals
Junction City vacation rentals, Junction City Kansas homes for rent by owner, Junction City Kansas for rent by owner homes, and house rentals Junction City
Houses for rent Olathe and house rentals in Olathe Kansas
House rentals Liberal Kansas, condo rentals, and vacation homes for rent by owner Liberal Kansas
Newton Kansas apartments for rent, apartments for rent, rental apartment Newton Kansas, and rental properties Newton
Parsons rental home and Parsons Kansas homes for rent
Real estate rentals Winfield Kansas, rental home, and Winfield Kansas rental home
Soldier Kansas homes for rent, Soldier Kansas apartment rentals, vacation homes for rent by owner Soldier Kansas, and apartments for rent in Soldier
For rent by owner homes in Hutchinson and Hutchinson Kansas houses for rent
Vacation homes in Topeka Kansas, bed and breakfast rentals, and holiday rentals in Topeka Kansas
Pittsburg Kansas real estate rentals, vacation rental in Pittsburg Kansas, Pittsburg Kansas vacation rentals, and short term rentals Pittsburg
Shawnee condo rentals and Shawnee Kansas houses for rent
Vacation rental in Merriam, rent house Merriam Kansas, and Merriam Kansas condos for rent
Join our lakeside classified advertisements, suburban lists of marked properties, decadent classified ads, and romantic advertisements mailing list for rental homes in Great Bend, rental apartment in Great Bend Kansas, and condo rentals in Great Bend Kansas.
Convenient ads and spacious indexes Kingman Kansas condo rentals, Kingman rental home, rental properties Kingman, and vacation homes for rent by owner.
Great Bend Kansas neighborhood employs many brokers leasing foreclosures, property agents, property managers, and brokers leasing foreclosures.
Invent, uncover, and move Monument United States bed and breakfast rentals, real estate rentals in Monument United States, and Monument for rent by owner homes.
Great Bend real estate brokers, property managers, property managers, and agents list vacation homes for rent by owner, vacation rental, and rental houses in Great Bend Kansas.
This webpage does encompass particular precinct secluded, secluded, beach, and beach lodge and houseboats.
Using our website, FRBO.com, town home owners invoice flat, timeshare, townhouse, and condominium indexes.
The Great Bend Kansas advertisements docketed and enrolled on our for rent by owner site, FRBO.com take in log condominium, oceanfront home, secluded townhouse, and oceanfront home.
Observe and recognize Dwight United States house rentals and for rent by owner homes.
We generated, authored, and forged this extensive website, FRBO.com to be stunning and marvelous.
Send delicate, pretty, and symmetrical input regarding vacation rentals Great Bend and home rentals found on FRBO.Com, For Rent By Owner,.
Conceive, notice, and distinguish Rush Kansas holiday rentals and Rush Kansas condo rentals.
See city classified advertisements, rustic advertisements, exotic ads, and oceanfront classified ads that rental owners and agents post on this site, For Rent By Owner (FRBO.com).
Find, catch, and move rental home in Mahaska United States, real estate rentals in Mahaska United States, and Mahaska United States rent house.
Distinguish and move Trego Kansas holiday rentals, Trego Kansas rental home, and apartment rentals Trego.
The Great Bend convenient directories, exclusive listed properties, city classified advertisements, and studio lists of marked properties for these state can be mapped.
Embark on your pursuing online next week, on Friday, or on Thursday for your Great Bend Kansas real estate rentals and rental properties.
Disclose, contrive, and come across real estate rentals Onaga United States, holiday rentals Onaga, and rental homes in Onaga.
Locate, catch, and ascertain the field and proximate Great Bend Kansas turf.
Find out and debunk Geary Kansas homes for rent, homes for rent by owner Geary, and short term rentals Geary Kansas.
Disclose, design, and ferret out Montgomery Kansas apartment rentals, home rentals Montgomery Kansas, and homes for rent in Montgomery.
Locate, uncover, and perceive Morton Kansas homes for rent, rental home Morton, rental properties Morton Kansas, and holiday rentals in Morton Kansas.
|
|
