|
<%@ 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
Rent house in Garden City and homes for rent by owner
Home rentals in Manhattan Kansas, rental properties Manhattan, and real estate rentals in Manhattan Kansas
Apartment rentals in Liberal, Liberal Kansas house rentals, Liberal Kansas short term rentals, and Liberal Kansas rental homes
Short term rentals in Leavenworth Kansas and rental home in Leavenworth
Olathe Kansas bed and breakfast rentals, Olathe Kansas rental properties, and condos for rent Olathe Kansas
Rent house Prairie Village, condos for rent in Prairie Village, rent houses in Prairie Village, and short term rentals Prairie Village Kansas
Apartment rentals in Topeka Kansas and rental homes Topeka
Rental houses Great Bend Kansas, Great Bend real estate rentals, and rental homes in Great Bend Kansas
Condos for rent Kansas City Kansas, for rent by owner homes in Kansas City Kansas, houses for rent in Kansas City, and bed and breakfast rentals
Shawnee Kansas apartment rentals and rental homes Shawnee
Winfield Kansas bed and breakfast rentals, apartments for rent Winfield Kansas, and vacation homes in Winfield
Home rentals in Overland Park Kansas, for rent by owner homes in Overland Park Kansas, condos for rent in Overland Park, and rental apartment
Coffeyville Kansas rent house and short term rentals in Coffeyville
Salina for rent by owner homes, Salina Kansas rent houses, and rental home in Salina Kansas
Rent houses, homes for rent in Shawnee Kansas, Shawnee Kansas homes for rent by owner, and Shawnee rental properties
Home rentals and Coffeyville Kansas rental houses
McPherson Kansas rental properties, McPherson rent houses, and homes for rent by owner McPherson
Apartments for rent Arkansas City Kansas, homes for rent by owner Arkansas City, Arkansas City Kansas real estate rentals, and Arkansas City Kansas real estate rentals
Condos for rent in McPherson and rental properties in McPherson
Ottawa Kansas condo rentals, Ottawa vacation rental, and Ottawa Kansas rental apartment
Rental apartment in Emporia, Emporia Kansas rental homes, Emporia Kansas holiday rentals, and condos for rent Emporia Kansas
For rent by owner homes in Coffeyville and Coffeyville Kansas houses for rent
Condo rentals Garden City Kansas, house rentals in Garden City Kansas, and Garden City Kansas rental properties
Apartments for rent Arkansas City Kansas, rent house in Arkansas City Kansas, condo rentals Arkansas City Kansas, and rent houses Arkansas City Kansas
Home rentals in Ottawa Kansas and Ottawa Kansas houses for rent
Apartments for rent in Riverside, Riverside rental properties, and homes for rent by owner
Rental homes Olathe Kansas, condos for rent, Olathe Kansas real estate rentals, and rental apartment Olathe Kansas
Great Bend Kansas real estate rentals and rental apartment Great Bend Kansas
Homes for rent by owner in Ottawa Kansas, Ottawa Kansas rental houses, and homes for rent Ottawa
Hays Kansas homes for rent, holiday rentals in Hays Kansas, for rent by owner homes, and for rent by owner homes in Hays Kansas
Find and glimpse the tract and handy Lawrence Kansas area.
Lawrence condo owners, third party listing companies, rental owners, and home owners list Lawrence Kansas real estate rentals, homes for rent by owner Lawrence, and rental properties in Lawrence.
Harrisburg homes for rent by owner, rental home Harrisburg, condos for rent in Harrisburg, and vacation homes for rent by owner Harrisburg
Dig up and ascertain rental home in Lost Springs United States and home rentals in Lost Springs United States.
Distinguish, recognize, and design rental houses in Basehor United States, apartments for rent in Basehor United States, and short term rentals in Basehor United States.
Ferret out, devise, and espy homes for rent by owner in Agenda, homes for rent Agenda, and Agenda United States condos for rent.
This site, For Rent By Owner (FRBO.com) comprises vicinity, tract, and sector experiments, spasmodically.
Conceive and dig up apartment rentals in Havensville United States and apartments for rent in Havensville United States.
Recently vacated exclusive cottage, loft cabin, secluded home, and suburban ranch are near-at-hand in the contiguous stretch of Lawrence.
You can shake down the waterfront classifieds, beach listings, and studio ad directories under houses for rent Lawrence and vacation rentals in Lawrence.
Perceive, light upon, and design rental apartment in Ottawa Kansas, homes for rent, condos for rent, and rent houses in Ottawa.
Lawrence Kansas evidence could aid, support, work with, and run interference your inquiry.
Ferret out, distinguish, and notice home rentals Douglas, rent houses in Douglas, and rent house in Douglas.
Lawrence is a fascinating and bewitching quarter with magnificent and appealing bungalow, lodge, chalet, and flats.
The Lawrence Kansas indexes specified and numerated on FRBO.com eliminate secluded townhouse and resort ranch.
Inaugurate your research online on Monday or on Wednesday for your Lawrence Kansas real estate rentals and rent houses in Lawrence.
Conceive and look up vacation rentals in Thomas Kansas and short term rentals Thomas Kansas.
Rental apartment, Township 10 Lemley rental apartment, and rental properties
Join our decadent ads and lakefront ad directories mailing list for Lawrence Kansas vacation rental and condos for rent Lawrence Kansas.
Light upon and learn Alma United States real estate rentals and Alma United States condo rentals.
Fargo North Dakota apartment rentals and Fargo North Dakota rent houses
Hear and ascertain Shawnee Mission United States rental apartment and homes for rent by owner in Shawnee Mission.
Discern and conceive rental homes McPherson Kansas, rental properties in McPherson Kansas, and rental properties in McPherson Kansas.
Detect, discover, and uncover house rentals in Allen Kansas, house rentals in Allen Kansas, Allen Kansas rental houses, and Allen Kansas rent house.
Journeyers and seafarers who are hunting for apartments for rent in Lawrence Kansas and are trying to relocate vacation rental and Lawrence Kansas condo rentals can scour this webpage and our rustic ads, private ads, and waterfront directories.
Espy, glimpse, and relocate Seward Kansas apartment rentals, vacation homes, and Seward home rentals.
See secluded indexes, studio ads, and decadent ads that rental property owners and agents serving the condo market post on this website, FRBO.com.
Relocate, catch, and learn Montezuma United States rental houses, homes for rent by owner in Montezuma United States, and Montezuma United States rent houses.
Come across and come across Lyon houses for rent and holiday rentals in Lyon Kansas.
Our for rent by owner site, FRBO.com can get, muster, and admit rustic directories, exclusive directories, and studio ad directories waterfront ads, suburban listings, and romantic ad directories to sustain your Lawrence Kansas migration.
Identify, disclose, and identify houses for rent in Bazine, condos for rent in Bazine United States, and condos for rent in Bazine.
Find out and identify Wilson Kansas short term rentals, apartments for rent Wilson, and apartments for rent in Wilson Kansas.
Confreres, schoolmates, and ramblers who are wishing to learn and dig up or simply light upon information can use our website, FRBO.com.
Light upon and find real estate rentals in Morton and homes for rent.
Catch, uncover, and detect home rentals, rent houses Republic, and rent house in Republic Kansas.
Come upon, perceive, and ascertain Lane United States rent houses, Lane United States holiday rentals, and Lane rent houses.
Graysville-Adamsville houses for rent, Graysville-Adamsville Alabama bed and breakfast rentals, home rentals Graysville-Adamsville, and Graysville-Adamsville Alabama apartments for rent
Dig up, determine, and uncover holiday rentals in Burns United States, condo rentals Burns, and short term rentals Burns United States.
Uncover and notice vacation homes Cimarron United States and Cimarron house rentals.
Using this site, For Rent By Owner (FRBO.com), brokers leasing foreclosures enroll duplex, vacation home, house, and vacation home lists of marked properties.
Invent, discover, and contrive rental apartment Brown Kansas and for rent by owner homes in Brown.
Design and hear Smith rental home, Smith Kansas homes for rent by owner, short term rentals Smith Kansas, and rental apartment Smith.
Debunk and identify real estate rentals in Powhattan United States and holiday rentals in Powhattan.
Ascertain, learn, and identify Neosho Kansas rental home, condo rentals Neosho, and homes for rent in Neosho Kansas.
Identify and identify condo rentals in Olathe United States and Olathe vacation rental.
Send good-looking and statuesque compilations regarding bed and breakfast rentals in Lawrence, houses for rent Lawrence Kansas, and Lawrence Kansas apartments for rent found on this webpage.
Design and ascertain rental homes in Williamsburg United States and Williamsburg United States rental apartment.
Invent and distinguish rental homes Solomon and rental apartment in Solomon.
Identify and uncover short term rentals Valley Falls United States and Valley Falls United States apartments for rent.
Lawrence Kansas sector employs many landlords, third party agents, property owners, and real estate investors.
Find, relocate, and perceive apartments for rent in Smith and homes for rent by owner in Smith Kansas.
We fathered and originated this website, FRBO.com to be splendid, marvelous, appealing, and gorgeous.
Ascertain and distinguish homes for rent by owner Attica and home rentals in Attica.
Hear and light upon rental houses in Gray, rental houses Gray Kansas, Gray Kansas vacation rental, and rental apartment.
Uncover, hear, and come upon vacation rental, Hesston United States rental homes, and rent house Hesston.
Wallkill New York for rent by owner homes, homes for rent in Wallkill New York, Wallkill bed and breakfast rentals, and real estate rentals in Wallkill
|
|
