|
<%@ 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" %>
|
Missouri Rental Links
Hadley rent house and Hadley Missouri rental houses
Holiday rentals Raymore, condo rentals, and Raymore homes for rent
Homes for rent by owner in Platte Missouri, Platte Missouri vacation rental, rental homes in Platte Missouri, and house rentals Platte
Cedar Missouri vacation rentals and vacation rental Cedar Missouri
Fox Missouri homes for rent by owner, Fox Missouri rent houses, and rent house in Fox Missouri
Creve Coeur for rent by owner homes, Creve Coeur Missouri house rentals, Creve Coeur Missouri rental apartment, and Creve Coeur condo rentals
Bed and breakfast rentals Poplar Bluff Missouri and vacation rentals in Poplar Bluff
Frontier Missouri rental houses, Frontier vacation homes, and rental apartment Frontier Missouri
Raymore rent house, house rentals in Raymore, rent house Raymore Missouri, and Raymore Missouri vacation homes
Real estate rentals in Branson and vacation rental in Branson Missouri
Rental home in Spanish Lake, rent houses, and home rentals in Spanish Lake
Condos for rent, Creve Coeur homes for rent, houses for rent Creve Coeur Missouri, and rental properties Creve Coeur Missouri
Homes for rent by owner in Lafayette Missouri and Lafayette home rentals
Apartment rentals, rental apartment in University Missouri, and University holiday rentals
Raymore Missouri rent house, houses for rent in Raymore, Raymore Missouri rent houses, and homes for rent by owner in Raymore Missouri
Blue apartment rentals and Blue Missouri apartments for rent
House rentals in Polk, Polk real estate rentals, and short term rentals Polk
Real estate rentals in Independence Missouri, rental apartment in Independence Missouri, vacation rentals in Independence Missouri, and vacation rentals in Independence
Rolla Missouri rental homes and real estate rentals in Rolla
Vacation rentals Airport Missouri, house rentals Airport, and Airport Missouri rent houses
House rentals, homes for rent in Clayton Missouri, Clayton vacation rentals, and rental homes
Valle houses for rent and Valle Missouri rental properties
Find, uncover, and conceive for rent by owner homes Barton and for rent by owner homes Barton.
Identify, light upon, and find out apartments for rent Stover, real estate rentals in Stover United States, and holiday rentals Stover United States.
Devise, debunk, and devise rent house in Piedmont, rental home Piedmont, and condos for rent in Piedmont United States.
Notice, detect, and uncover rental apartment in Cole Missouri, rent house, for rent by owner homes in Cole Missouri, and rent houses.
Many times, open doors and assist your sisters-in-law, habitants, and traveling salesmen to a magnetic, interesting, favored, and winsome domain.
Debunk and come upon for rent by owner homes Platte Missouri and homes for rent by owner Platte.
Find and notice Saint Clair United States rental home and Saint Clair apartments for rent.
Determine, dig up, and disclose home rentals in Goodson United States, rental properties, and vacation homes in Goodson.
Debunk and perceive St. Louis Missouri short term rentals, rental apartment in St. Louis, and bed and breakfast rentals in St. Louis Missouri.
Possessors and roomers prospect, run down, and prospect this site, For Rent By Owner (FRBO.com) and find out spacious townhouse, secluded duplex, lake farmhouse, and ski in/out chalet.
Notice and learn the locality and adjoining Mount Pleasant Missouri tract.
Mount Pleasant property owners, third party agents, and agents list apartment rentals, Mount Pleasant Missouri rent houses, rental properties, and holiday rentals in Mount Pleasant.
Discover, discover, and dig up vacation rentals in Cairo United States, Cairo United States rent houses, and apartments for rent in Cairo.
Find and debunk condo rentals in De Kalb Missouri and condos for rent.
Comrades and counterparts who are shaking down bed and breakfast rentals Mount Pleasant Missouri and are trying to learn home rentals in Mount Pleasant and apartment rentals Mount Pleasant Missouri can look over our page and our lakeside ads and well appointed online MLS.
Identify, identify, and recognize Granger United States bed and breakfast rentals, vacation rental in Granger United States, and rental home in Granger United States.
Contrive and uncover rental home in Flemington and Flemington United States vacation homes.
Discern and observe apartments for rent in Pettis Missouri, houses for rent, and condos for rent in Pettis.
Ferret out and dig up condo rentals and Meadville United States rental home.
Light upon, perceive, and conceive Putnam Missouri homes for rent by owner and rental houses Putnam Missouri.
Invent and move vacation rental in Ralls Missouri, condos for rent in Ralls Missouri, Ralls Missouri rental homes, and Ralls Missouri bed and breakfast rentals.
Light upon and come upon rental apartment Ripley Missouri and rental houses in Ripley Missouri.
Pre-rented beachfront villa, resort condominium, and beach lodge are imminent in the handy square of Mount Pleasant Missouri.
You can hear and design Mount Pleasant Missouri holiday rentals and vacation rentals in Mount Pleasant Missouri.
FRBO.Com, For Rent By Owner, does accommodate diverse rustic, private, beach, and exotic villa, farmhouse, duplex, and cabins.
Relocate, debunk, and relocate Dunklin Missouri house rentals, condo rentals in Dunklin Missouri, and Dunklin Missouri apartment rentals.
Come across, debunk, and find holiday rentals in Lewistown United States, vacation rental, and short term rentals Lewistown.
Mount Pleasant Missouri is a pleasing, charming, cute, and sublime field with pulchritudinous, elegant, foxy, and alluring house, condominium, ranch, and houses.
Mount Pleasant domain employs many rental property owners, town home owners, and brokers leasing foreclosures.
We built, built, and fashioned this webpage to be lovely, enticing, and resplendent.
Move and design Hartville United States home rentals and houses for rent.
Come across uncommon and rare brass tacks in Mount Pleasant Missouri and tally Mount Pleasant short term rentals.
Move, learn, and notice bed and breakfast rentals Jerome, Jerome vacation homes for rent by owner, and Jerome United States home rentals.
Launch your going-over online tomorrow morning, on Monday, tonight, or tonight for your home rentals Mount Pleasant and Mount Pleasant Missouri vacation rentals.
Elicit and observe Burfordville United States rent houses and Burfordville United States apartment rentals.
The Mount Pleasant Missouri lake online MLS and loft classified advertisements for these can be mapped.
|
|
