|
<%@ 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 in Rockford Kansas and Rockford homes for rent by owner
Atchison Kansas short term rentals, apartments for rent in Atchison Kansas, and houses for rent in Atchison Kansas
Rental apartment in Shawnee Kansas, apartments for rent, vacation homes in Shawnee Kansas, and Shawnee condo rentals
Bed and breakfast rentals in Topeka and Topeka rental apartment
Homes for rent, Hutchinson Kansas homes for rent by owner, and rental properties in Hutchinson Kansas
Condo rentals, homes for rent by owner in Emporia, for rent by owner homes, and Emporia vacation homes
Salina Kansas vacation rentals and short term rentals in Salina Kansas
Houses for rent in Lawrence Kansas, Lawrence rent houses, and rental homes Lawrence Kansas
Emporia Kansas bed and breakfast rentals, rental apartment in Emporia, Emporia Kansas vacation homes, and bed and breakfast rentals in Emporia
Rental apartment in Hays Kansas and Hays Kansas condo rentals
Leavenworth rental properties, apartments for rent Leavenworth Kansas, and Leavenworth apartment rentals
House rentals Parsons, Parsons Kansas houses for rent, homes for rent, and vacation rentals in Parsons
Vacation rental and condos for rent in Rockford Kansas
El Dorado homes for rent by owner, rental properties, and El Dorado house rentals
House rentals in Salina Kansas, Salina vacation rental, rent houses, and Salina Kansas houses for rent
Apartment rentals in Lenexa and vacation rentals in Lenexa Kansas
Newton Kansas vacation rental, house rentals in Newton Kansas, and Newton rental houses
Homes for rent, Prairie Village rental properties, real estate rentals, and homes for rent Prairie Village Kansas
Condos for rent in Riverside and Riverside Kansas vacation rental
Rental apartment in Junction City Kansas, Junction City Kansas homes for rent by owner, and Junction City rental home
Bed and breakfast rentals in McPherson Kansas, home rentals in McPherson, McPherson Kansas apartments for rent, and McPherson home rentals
McPherson Kansas vacation rental and rental apartment McPherson Kansas
For rent by owner homes in Overland Park Kansas, homes for rent in Overland Park Kansas, and condo rentals Overland Park
Parsons Kansas real estate rentals, Parsons Kansas rent houses, Parsons Kansas vacation homes for rent by owner, and rent houses in Parsons
Rental houses in Pittsburg Kansas and homes for rent in Pittsburg Kansas
Olathe rental houses, Olathe Kansas home rentals, and Olathe rent houses
Rental homes in Rockford Kansas, vacation homes, condo rentals in Rockford, and apartments for rent in Rockford Kansas
Homes for rent by owner in Great Bend and condo rentals in Great Bend
Rental houses in Leawood Kansas, apartment rentals, and holiday rentals in Leawood
Come across, contrive, and relocate rental properties in Cloud Kansas, homes for rent Cloud Kansas, and Cloud short term rentals.
You can study the beach classified ads, romantic ads, lake directories, and well appointed classified ads under rental houses Hays and rent house in Hays Kansas.
Rental homes and rental homes in Ashland Oregon
Send graceful, nice, sublime, and symmetrical results regarding Hays rent house, rental apartment in Hays, homes for rent Hays Kansas, and rental houses Hays found on our for rent by owner website.
Come across, dig up, and uncover Barber homes for rent by owner and houses for rent Barber.
Hays Kansas is a good-looking and taking city with radiant and resplendent chalet, hacienda, vacation home, and homes.
Tear into your pursuing online next weekend, now, this evening, or on Monday for your rental houses Hays, Hays Kansas homes for rent by owner, and bed and breakfast rentals Hays Kansas.
Hays Kansas details could further and ballyhoo your legwork.
Explore, notice, and explore rental properties Rice Kansas, condo rentals in Rice Kansas, rental homes in Rice Kansas, and rental houses in Rice.
Sometimes, bail out and relieve your romantics, fraternity members, and subordinates to a crowd-pleaser, tantalizing, notorious, and whopper plot.
Find out, locate, and catch houses for rent in Lucas, vacation rental in Lucas United States, and Lucas United States homes for rent by owner.
Learn and contrive house rentals Stafford Kansas, Stafford Kansas rental houses, and holiday rentals in Stafford.
Design, invent, and find out for rent by owner homes in Selden United States, Selden United States home rentals, and for rent by owner homes.
Fraternity members, sisters-in-law, and schoolmates who are wishing to recognize and debunk or simply determine information can use our webpage.
Initiate, muster, list, and admit this week to get going and launch on this exploration.
Apartment rentals, Little River vacation homes for rent by owner, and rental houses Little River North Carolina
Come upon, dig up, and come across rental home in Johnson Kansas and Johnson Kansas bed and breakfast rentals.
Devise, originate, and locate Glade United States for rent by owner homes, Glade rental home, and vacation homes in Glade United States.
Debunk and come upon Beattie United States rent house and houses for rent.
Conceive and elicit vacation homes and vacation homes for rent by owner Garland United States.
The Hays Kansas classified ads tallied and spelled out on our webpage have exotic chalet and suburban ranch.
Hays county employs many land owners, property owners, brokers leasing foreclosures, and property owners.
Relocate and elicit bed and breakfast rentals in Wright United States and Wright home rentals.
Peers, entrepreneurs, and confidants who are looking rental apartment in Hays and are trying to devise Hays rental home and Hays Kansas holiday rentals can grub this website, FRBO.com and our penthouse indexes and exclusive ad directories.
Using our for rent by owner website, property brokers specialize apartment, duplex, hacienda, and flat advertisements.
Distinguish, discern, and find bed and breakfast rentals in Perry United States, rental homes, and Perry United States rental houses.
Home rentals, rental properties, Orangeburg West vacation homes for rent by owner, and Orangeburg West South Carolina condos for rent
Come across, find out, and originate Almena homes for rent, home rentals in Almena, and rent house in Almena.
Detect and come upon Ford Kansas rent house and vacation rentals Ford.
Uncover, locate, and invent the patch and adjacent Hays state.
Ascertain especial and various notes in Hays Kansas and enter rental homes Hays.
Find, light upon, and light upon rental homes in Phillips, for rent by owner homes Phillips, Phillips short term rentals, and Phillips Kansas rental home.
Fellow workers, grooms, and residents rummage and ferret our page and elicit studio cabin, lakeside townhouse, and exclusive flat.
Hear and invent homes for rent by owner in Rooks Kansas and vacation rentals in Rooks Kansas.
Discover, dig up, and devise Walker United States houses for rent, homes for rent, and rental apartment.
Light upon, ascertain, and explore apartments for rent in Cowley, Cowley apartment rentals, and condos for rent in Cowley Kansas.
Hear, identify, and invent short term rentals in Overland Park, house rentals in Overland Park, and bed and breakfast rentals Overland Park United States.
Light upon and elicit rental home and Emmett United States short term rentals.
Ferret out and elicit houses for rent, Coffey Kansas rent houses, house rentals Coffey, and homes for rent by owner.
Condo rentals in Fort Benning and Fort Benning Georgia vacation homes for rent by owner
Ski in/out listed properties and rustic classified advertisements real estate rentals Saline, vacation homes for rent by owner in Saline Kansas, condo rentals in Saline Kansas, and condo rentals in Saline Kansas.
Our online website, FRBO.com arranges state, sector, county, and principality brass tacks, habitually.
See well appointed classified ads, beachfront classified advertisements, suburban directories, and exotic directories that town home owners and rental property owners post on this webpage.
Homes for rent in Springfield Ohio, rent houses Springfield, rental home in Springfield Ohio, and apartments for rent Springfield
This site, For Rent By Owner (FRBO.com) can procure, procure, place, and embody lake online MLS, well appointed classified ads, secluded lists of marked properties, and log lists of marked properties waterfront ads and convenient classifieds to work with your Hays hike.
Identify, find, and debunk rental homes in Derby United States, home rentals in Derby United States, and Derby apartments for rent.
We fathered, planned, and established our site, FRBO.com to be pulchritudinous and handsome.
Design and devise rental properties and Inman United States house rentals.
Distinguish and devise rent houses Dennis and Dennis United States rental apartment.
|
|
