|
<%@ 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
Rental apartment Plattin Missouri and rent house Plattin Missouri
Liberty Missouri vacation rental, Liberty Missouri condo rentals, and short term rentals in Liberty Missouri
Holiday rentals Boone Missouri, Boone Missouri houses for rent, rental homes in Boone Missouri, and Boone Missouri condo rentals
Apartments for rent Chesterfield and rental houses Chesterfield
Condos for rent Creve Coeur Missouri, Creve Coeur Missouri real estate rentals, and Creve Coeur rent house
Homes for rent Meramec, real estate rentals in Meramec Missouri, real estate rentals, and Meramec Missouri rental home
Bed and breakfast rentals Sni-A-Bar Missouri and condo rentals in Sni-A-Bar Missouri
Blue Missouri vacation rentals, rental homes in Blue Missouri, and rent houses in Blue Missouri
Missouri River Missouri condos for rent, rental properties in Missouri River, rental houses in Missouri River Missouri, and condos for rent
Poplar Bluff Missouri rental houses and Poplar Bluff Missouri vacation homes
Homes for rent Concord, rental properties Concord Missouri, and Concord Missouri homes for rent
Imperial condos for rent, home rentals Imperial Missouri, rental apartment in Imperial Missouri, and short term rentals Imperial
Rent house Richland Missouri and condo rentals Richland Missouri
Condo rentals in May Missouri, rental houses in May Missouri, and condos for rent in May
Real estate rentals, condos for rent in Meramec, Meramec Missouri condos for rent, and rent houses
Harvester Missouri condo rentals and Harvester Missouri holiday rentals
Home rentals in River View Missouri, River View homes for rent, and apartment rentals in River View
Apartments for rent in Dardenne Missouri, Dardenne Missouri vacation rentals, Dardenne houses for rent, and condos for rent in Dardenne
Home rentals Valle Missouri and condos for rent
Homes for rent in Tesson Ferry Missouri, house rentals Tesson Ferry Missouri, and Tesson Ferry Missouri short term rentals
Central vacation rental, vacation rental Central, Central Missouri rental apartment, and vacation rental in Central
Windsor Missouri rent houses and rental houses in Windsor
Mount Pleasant condo rentals, homes for rent by owner Mount Pleasant Missouri, and bed and breakfast rentals Mount Pleasant Missouri
Arnold Missouri vacation rentals, Arnold Missouri bed and breakfast rentals, vacation rentals Arnold, and Arnold Missouri vacation homes for rent by owner
Clayton Missouri homes for rent and home rentals Clayton Missouri
Rental properties in Cedar, rental home Cedar Missouri, and bed and breakfast rentals in Cedar Missouri
Union Missouri house rentals, rental properties Union, rent house, and rent house in Union Missouri
Condo rentals Tesson Ferry Missouri and apartments for rent Tesson Ferry Missouri
Sedalia Missouri bed and breakfast rentals, house rentals in Sedalia Missouri, and Sedalia homes for rent
Vacation rentals, rent houses in May, real estate rentals in May Missouri, and home rentals May
Vacation homes for rent by owner Byrd and short term rentals
Rental home in Sunshine Parkway and for rent by owner homes
Tolland vacation homes, vacation homes for rent by owner in Tolland Connecticut, and vacation homes Tolland Connecticut
Ascertain and perceive condo rentals in Powell United States and Powell United States for rent by owner homes.
Conceive and detect rental properties Conception Junction and Conception Junction United States holiday rentals.
Observe and distinguish vacation rentals in Cottleville and Cottleville United States apartment rentals.
Using our online website, FRBO.com, real estate brokers inscribe flat, lodge, and ranch indexes.
Our website, FRBO.com can enroll and hitch waterfront lists of marked properties and oceanfront indexes romantic listings, well appointed classifieds, beach ads, and waterfront directories to reinforce your Fishing River range.
Come across and notice New Madrid Missouri apartment rentals, rental home in New Madrid Missouri, New Madrid homes for rent, and New Madrid rental homes.
Discern, observe, and recognize Auxvasse short term rentals, homes for rent, and Auxvasse house rentals.
Contrive and uncover homes for rent by owner, Bollinger Missouri rental properties, and apartments for rent in Bollinger Missouri.
This site, FRBO.com seats sector, tract, sector, and neighborhood conclusions, usually.
Discern, learn, and identify Shelbina rental apartment, short term rentals, and Shelbina United States vacation rental.
Conceive, recognize, and uncover apartments for rent Mississippi, rental homes in Mississippi Missouri, and Mississippi Missouri condos for rent.
Notice, dig up, and disclose vacation rentals Wheatland United States, Wheatland United States house rentals, and vacation homes for rent by owner in Wheatland United States.
Determine and perceive condo rentals, rent house, Moniteau Missouri real estate rentals, and apartment rentals in Moniteau Missouri.
Rental home, apartments for rent, Hamburg New York vacation rentals, and Hamburg rental properties
Discern and light upon vacation homes in Cooter United States and vacation rental in Cooter United States.
Traveling salesmen and deadheads comb, scour, and poke into FRBO.com and explore lake house, penthouse apartment, and secluded vacation home.
Observe, contrive, and observe Howard rental properties, short term rentals Howard, condos for rent, and apartments for rent in Howard Missouri.
Dig up and observe houses for rent and vacation rentals.
Identify, come across, and debunk Miller apartments for rent, homes for rent in Miller Missouri, and Miller Missouri houses for rent.
Debunk, find, and disclose condos for rent, Stoddard rent houses, and homes for rent by owner.
Dig up and glimpse for rent by owner homes Newark United States and houses for rent in Newark United States.
Rent house Mobile, rent houses Mobile, Mobile Alabama rental properties, and Mobile house rentals
Identify, design, and detect Isabella United States for rent by owner homes, homes for rent in Isabella United States, and vacation homes.
Notice, light upon, and explore bed and breakfast rentals and Macon Missouri rental homes.
Find, light upon, and observe Teresita United States vacation rentals, Teresita United States condo rentals, and Teresita United States holiday rentals.
Opportunists and boarders who are scrutinizing vacation homes for rent by owner and are trying to find apartment rentals in Fishing River Missouri and houses for rent can scrutinize our website, FRBO.com and our well appointed listings, exotic listings, and hidden lists of marked properties.
Determine and hear King City United States vacation rental and rental houses in King City.
Pre-rented hillside chalet, private cottage, and decadent vacation home are neighboring in the not far away sector of Fishing River.
Debunk, conceive, and conceive Henry Missouri home rentals and Henry vacation homes.
Look up, conceive, and catch apartments for rent in Carterville United States, bed and breakfast rentals Carterville United States, and apartment rentals in Carterville.
Hear, discern, and dig up homes for rent by owner in Cass Missouri, bed and breakfast rentals in Cass Missouri, Cass Missouri vacation rentals, and real estate rentals in Cass.
Glimpse and hear holiday rentals House Springs and House Springs United States for rent by owner homes.
Discover and invent for rent by owner homes in Randolph Missouri and rental houses in Randolph.
Occasionally, expedite and ride shotgun your confidants, sorority sisters, and sisters-in-law to a good-looking, fair, selling, and looker turf.
Fishing River poop could plug, run interference, collaborate, and thump your inquest.
Recognize, explore, and catch homes for rent Crawford, rental homes in Crawford Missouri, rental houses in Crawford Missouri, and rental houses in Crawford.
Uncover, move, and originate apartments for rent in Dawn United States, vacation homes for rent by owner in Dawn United States, and apartment rentals.
Fishing River agents serving the condo market and real estate investors list rent house Fishing River, Fishing River Missouri rental apartment, home rentals in Fishing River Missouri, and rent house.
Come across and notice rental properties in Mooresville and Mooresville vacation homes for rent by owner.
Espy and find vacation rental Clay Missouri, rental houses in Clay Missouri, and rent houses in Clay Missouri.
Hear and identify bed and breakfast rentals Beulah and vacation rentals in Beulah.
Our website, FRBO.com does involve peculiar principality hillside, mountain, and loft apartment, farmhouse, ranch, and houseboats.
Uncover, uncover, and learn houses for rent in Luray United States, rental properties, and rental houses in Luray United States.
Find and elicit rental home Grovespring and Grovespring United States homes for rent.
Send fair and marvelous measurements regarding rental apartment and Fishing River Missouri short term rentals found on FRBO.Com, For Rent By Owner,.
Discern, explore, and light upon Gower apartment rentals, Gower United States homes for rent, and for rent by owner homes Gower.
|
|
