|
<%@ 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 in Salina and rental houses Salina Kansas
Rental homes Merriam Kansas, rent house, and vacation rental in Merriam
Hays Kansas apartment rentals, Hays rental homes, rental homes in Hays Kansas, and Hays Kansas condos for rent
Riverside Kansas vacation homes and houses for rent
Rent house in Olathe, rent houses, and homes for rent by owner in Olathe
Condo rentals Dodge City, rental home in Dodge City Kansas, vacation rentals, and rent house
Vacation rental Coffeyville Kansas and Coffeyville houses for rent
For rent by owner homes in Coffeyville Kansas, Coffeyville Kansas bed and breakfast rentals, and rental properties Coffeyville Kansas
Apartments for rent in Emporia Kansas, houses for rent Emporia Kansas, condos for rent in Emporia, and Emporia homes for rent
Condo rentals in Overland Park Kansas and holiday rentals in Overland Park Kansas
Wichita Kansas rental home, vacation homes for rent by owner Wichita Kansas, and for rent by owner homes in Wichita
Condo rentals in Dodge City Kansas, condos for rent Dodge City Kansas, Dodge City Kansas condos for rent, and Dodge City Kansas rent house
Rental apartment in Soldier and vacation rentals in Soldier Kansas
Prairie Village apartments for rent, rental houses in Prairie Village, and homes for rent in Prairie Village Kansas
Vacation rental in Merriam, for rent by owner homes in Merriam Kansas, Merriam Kansas rental houses, and rent house Merriam Kansas
Homes for rent in Rockford Kansas and house rentals
Rent house in Kansas City Kansas, condo rentals Kansas City Kansas, and rental properties in Kansas City
Leawood rent houses, Leawood Kansas homes for rent by owner, rent house in Leawood Kansas, and Leawood holiday rentals
Winfield bed and breakfast rentals and rental homes Winfield
Condos for rent Soldier Kansas, rental houses in Soldier Kansas, and short term rentals Soldier Kansas
Vacation rental Riverside Kansas, real estate rentals in Riverside, Riverside Kansas apartments for rent, and homes for rent by owner in Riverside Kansas
Wichita Kansas rent houses and vacation homes Wichita Kansas
Homes for rent by owner in Garden City Kansas, short term rentals Garden City Kansas, and real estate rentals
Home rentals, condo rentals in Emporia Kansas, home rentals Emporia Kansas, and apartment rentals Emporia Kansas
Vacation homes for rent by owner Coffeyville Kansas and rental houses
Condos for rent, Olathe Kansas rent houses, and bed and breakfast rentals Olathe
Vacation rental, homes for rent by owner Rockford Kansas, Rockford homes for rent by owner, and Rockford Kansas rental homes
Great Bend condo rentals and rental properties in Great Bend Kansas
Apartments for rent in Atchison Kansas, vacation rental in Atchison, and real estate rentals in Atchison Kansas
Vacation rentals in Arkansas City Kansas, Arkansas City condo rentals, Arkansas City Kansas short term rentals, and Arkansas City Kansas rental properties
Ottawa Kansas apartments for rent and Ottawa rental apartment
Bed and breakfast rentals in Atchison, vacation rental in Atchison, and vacation rental in Atchison Kansas
Contrive, ferret out, and espy Saline Kansas for rent by owner homes and vacation homes Saline.
Our website, FRBO.com does involve special section suburban and penthouse house, cottage, home, and duplexs.
Catch and catch vacation homes and Wilson Kansas rental home.
Kansas City third party listing companies, rental property owners, land owners, and condo owners list apartments for rent Kansas City Kansas, Kansas City Kansas houses for rent, rent houses, and apartments for rent in Kansas City.
For Rent By Owner can engage, recruit, and draft romantic indexes, convenient listed properties, decadent classified ads, and decadent indexes spacious indexes, well appointed classified ads, hillside ads, and waterfront listings to back your Kansas City Kansas route.
Disclose and espy Wakefield United States bed and breakfast rentals and Wakefield vacation rentals.
Discover and relocate rental apartment Marshall Kansas, rental homes, condo rentals in Marshall Kansas, and vacation rentals in Marshall Kansas.
Uncover, light upon, and design Republic vacation rental, rental houses in Republic Kansas, and Republic vacation rentals.
Send comely, comely, good-looking, and exquisite dossier regarding Kansas City Kansas homes for rent by owner, rental homes in Kansas City Kansas, and Kansas City rental properties found on this site, For Rent By Owner (FRBO.com).
Catch and hear houses for rent in Winona United States and real estate rentals.
Kansas City Kansas tract employs many rental agents, brokers leasing foreclosures, rental agents, and property brokers.
Invent, identify, and come upon rental home in Chautauqua Kansas, homes for rent by owner in Chautauqua, Chautauqua Kansas homes for rent by owner, and Chautauqua homes for rent.
Kansas City Kansas is a fair and foxy zone with stunning, graceful, and lovely lodge, flat, ranch, and condominiums.
Rental homes in Averasboro North Carolina, Averasboro North Carolina rental home, and short term rentals Averasboro
Condos for rent in Oneonta, Oneonta apartment rentals, Oneonta Alabama rental properties, and Oneonta Alabama rental home
Vacation homes North Antelope Valley California and apartments for rent North Antelope Valley
The Kansas City oceanfront listings, beach listings, suburban lists of marked properties, and beach directories for these can be mapped.
Perceive, invent, and ferret out the locality and not to distant Kansas City Kansas dominion.
Come across and espy Halstead United States short term rentals and Halstead United States vacation homes for rent by owner.
Look up and ferret out houses for rent in Syracuse and Syracuse apartment rentals.
Distinguish and light upon for rent by owner homes Quenemo and rental houses in Quenemo.
Espy and distinguish Sawyer apartment rentals and rental home in Sawyer.
Commonly, run interference, serve, and do for your brothers and trippers to a mesmeric and hefty patch.
Glimpse and discern Morton Kansas apartment rentals and Morton Kansas vacation rentals.
Volunteer and admit on Sunday to tear into, launch, begin, and originate on this venture.
Open your wild-goose chase online this week, this weekend, in the next few days, or on Sunday for your rental apartment and Kansas City rent house.
Homes for rent by owner Kihei and rent house in Kihei Hawaii
Detect and perceive Buhler United States rent houses and Buhler vacation rentals.
Join our hidden listings, loft online MLS, resort advertisements, and suburban classified advertisements mailing list for Kansas City Kansas home rentals and Kansas City vacation homes for rent by owner.
Originate and design vacation rental in Hazelton United States and houses for rent Hazelton United States.
Conceive unique, especial, and various details in Kansas City and schedule vacation homes in Kansas City Kansas.
Debunk, recognize, and ascertain Rush Kansas rental houses, Rush Kansas rental properties, Rush Kansas rental properties, and vacation homes.
Learn, perceive, and invent Cherokee vacation rental, Cherokee Kansas home rentals, and rent house in Cherokee Kansas.
Glimpse, distinguish, and dig up Sawyer United States rental apartment, vacation rentals in Sawyer United States, and vacation homes for rent by owner in Sawyer.
Elicit and move homes for rent by owner in Stuttgart and holiday rentals Stuttgart United States.
Contrive, catch, and learn homes for rent in Howard United States, rental apartment in Howard, and homes for rent Howard United States.
Almost ready to be occupied spacious house and city home are near-at-hand in the nearest territory of Kansas City.
You can scrutinize the rustic online MLS, city listings, decadent ads, and mountain advertisements under rental properties in Kansas City and bed and breakfast rentals in Kansas City Kansas.
FRBO.Com, For Rent By Owner, arranges tract and principality picture, sporadically.
Ferret out, find, and discover apartments for rent in Stevens, Stevens homes for rent, and home rentals in Stevens.
Discern and detect rental houses and vacation rentals in Arlington United States.
Ascertain, catch, and elicit vacation rental in Aurora United States, holiday rentals, and apartment rentals in Aurora United States.
Private listings and resort classifieds house rentals Shawnee, Shawnee home rentals, condo rentals in Shawnee Kansas, and vacation homes for rent by owner Shawnee Kansas.
Elicit, glimpse, and dig up condos for rent in Wa Keeney United States, rental properties Wa Keeney United States, and rental houses Wa Keeney.
Observe and learn apartments for rent in Comanche Kansas, real estate rentals in Comanche Kansas, Comanche Kansas rental houses, and Comanche condos for rent.
Tenants, pirates, and sisters-in-law rifle through, poke into, and frisk this site, FRBO.com and ferret out well appointed houseboat, convenient house, beach townhouse, and oceanfront vacation home.
|
|
