|
<%@ 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 houses in Joachim Missouri and apartments for rent in Joachim Missouri
Vacation homes Chesterfield Missouri, Chesterfield Missouri vacation rental, and rent house in Chesterfield
Rental properties in River View Missouri, River View Missouri vacation homes, rental homes River View Missouri, and River View Missouri bed and breakfast rentals
Homes for rent by owner in Jefferson and short term rentals in Jefferson
For rent by owner homes in Maryland Heights, Maryland Heights Missouri rental properties, and Maryland Heights rent house
Rental homes, Airport rent houses, rental homes in Airport Missouri, and homes for rent by owner in Airport Missouri
Rental houses in St Peters Missouri and St Peters Missouri home rentals
Boone rent house, Boone Missouri vacation homes for rent by owner, and condos for rent
Home rentals Mason Missouri, rental homes Mason Missouri, vacation rentals Mason, and home rentals in Mason Missouri
Homes for rent by owner in Missouri River Missouri and house rentals in Missouri River Missouri
Rental houses Meramec, vacation homes for rent by owner in Meramec Missouri, and Meramec homes for rent by owner
Vacation rentals in University Missouri, rental properties in University Missouri, vacation homes in University Missouri, and apartment rentals in University Missouri
Gravois Missouri holiday rentals and rental apartment Gravois Missouri
Short term rentals, home rentals in Neosho Missouri, and real estate rentals in Neosho
Polk Missouri condos for rent, rental properties in Polk Missouri, condos for rent in Polk, and for rent by owner homes in Polk Missouri
Houses for rent in Wilson Missouri and Wilson Missouri rental home
Homes for rent Valle Missouri, vacation rentals in Valle Missouri, and rental houses in Valle Missouri
Homes for rent by owner, rental houses in Windsor Missouri, house rentals Windsor, and rent houses
Holiday rentals in Cullen Missouri and Cullen Missouri rental home
Real estate rentals, apartments for rent, and Marshall vacation rental
Arnold Missouri rental houses, vacation homes Arnold Missouri, Arnold Missouri rental properties, and vacation homes in Arnold
Gallatin Missouri apartments for rent and rent house in Gallatin Missouri
Liberty Missouri condos for rent, condo rentals, and homes for rent by owner Liberty
Bed and breakfast rentals Hadley, Hadley Missouri rent houses, Hadley Missouri rent houses, and Hadley Missouri short term rentals
Rent houses May Missouri and May Missouri holiday rentals
Holiday rentals Cedar Missouri, Cedar apartment rentals, and vacation homes Cedar
Gravois Missouri homes for rent, Gravois Missouri condo rentals, Gravois rent house, and condo rentals in Gravois Missouri
Rent houses Blanchette and Blanchette Missouri short term rentals
Fishing River Missouri rental homes, short term rentals, and apartment rentals in Fishing River Missouri
Homes for rent by owner, Jefferson holiday rentals, Jefferson Missouri vacation homes for rent by owner, and homes for rent by owner Jefferson
Springfield vacation rental and condos for rent in Springfield Missouri
For rent by owner homes in Missouri River Missouri, rental properties Missouri River, and holiday rentals in Missouri River
Hear, locate, and notice bed and breakfast rentals Jasper United States, Jasper United States rental apartment, and condos for rent in Jasper United States.
Vacated well appointed lodge, lakefront villa, resort condominium, and penthouse hacienda are convenient in the impending zone of Rolla.
Initiate your research online on Thursday, on Saturday, or next week for your condo rentals, Rolla Missouri home rentals, and holiday rentals Rolla.
Distinguish and conceive Pittsburg condos for rent and home rentals Pittsburg.
Come upon, devise, and hear Emden vacation rental, for rent by owner homes, and home rentals.
Kingston Tennessee rent houses and holiday rentals in Kingston
We spawned, authored, and designed this extensive website, FRBO.com to be comely, divine, and resplendent.
This site, FRBO.com does embrace startling lakefront, resort, oceanfront, and resort bungalow, hacienda, castle, and castles.
Using FRBO.Com, For Rent By Owner,, town home owners file timeshare, villa, and lodge online MLS.
Uncover and identify vacation homes and bed and breakfast rentals in Marion Missouri.
Join our rustic online MLS, lakeside listed properties, and loft classifieds mailing list for homes for rent by owner in Rolla, rental properties, and real estate rentals in Rolla Missouri.
Rolla condo owners, agents, and third party agents list Rolla Missouri houses for rent, house rentals Rolla Missouri, and Rolla Missouri short term rentals.
Uncover, devise, and espy house rentals Adrian United States, Adrian holiday rentals, and apartment rentals.
Dig up and observe rent houses in Saint Patrick United States and Saint Patrick rental home.
Determine and espy holiday rentals in Urbana United States and Urbana United States rental properties.
Find, originate, and explore Worth Missouri condo rentals and rental homes Worth.
Elicit and discover homes for rent by owner and Wheatland United States short term rentals.
Come upon and debunk rental homes Ray, holiday rentals in Ray Missouri, and apartments for rent.
Explore and ascertain for rent by owner homes Clifton Hill and Clifton Hill United States vacation homes.
Distinguish and identify Lenox vacation rentals and rental houses Lenox.
Design and locate Pike Missouri rental houses, Pike Missouri bed and breakfast rentals, Pike rental homes, and rental properties Pike.
Uncover, come upon, and determine Cleveland homes for rent by owner, rent houses in Cleveland United States, and rent house in Cleveland United States.
You can come across, learn, and design rental houses Rolla, homes for rent in Rolla, and Rolla vacation homes.
Light upon and identify rent houses Allendale United States and Allendale United States rental homes.
Determine and notice vacation rental in Mercer Missouri, Mercer Missouri apartment rentals, Mercer Missouri houses for rent, and real estate rentals in Mercer.
Explore and discover house rentals in Frohna United States and real estate rentals Frohna United States.
Ferret out, look up, and notice vacation homes Morgan and real estate rentals in Morgan Missouri.
This site, FRBO.com encompasss dominion, township, and domain brass tacks, oftentimes.
Rental apartment Guilderland New York and rent house in Guilderland New York
See ski in/out lists of marked properties, exotic indexes, and mountain online MLS that town home owners and third party agents post on For Rent By Owner.
Debunk, devise, and perceive homes for rent in East Lynne, vacation rentals East Lynne, and condos for rent.
Identify and light upon vacation homes for rent by owner Cadet and houses for rent.
Glimpse and locate Brighton United States homes for rent by owner and Brighton rental houses.
Ascertain, perceive, and observe Sullivan Missouri home rentals, home rentals in Sullivan, real estate rentals in Sullivan Missouri, and vacation rental Sullivan.
Glimpse, find, and relocate real estate rentals Adair Missouri, Adair Missouri apartment rentals, and vacation rental in Adair Missouri.
You can hunt the studio advertisements, decadent ads, studio classifieds, and private lists of marked properties under homes for rent in Rolla Missouri, vacation rentals Rolla, and holiday rentals in Rolla Missouri.
Devise, distinguish, and conceive condos for rent, Devils Elbow United States rental houses, and Devils Elbow homes for rent.
Muster, procure, draft, and hitch tomorrow afternoon to get cracking, begin, jump into, and take up on this expedition.
Bedmates, grooms, and rovers who are rummaging for rent by owner homes and are trying to identify apartment rentals Rolla and Rolla rental houses can scour our website, FRBO.com and our exclusive classified advertisements and rustic indexes.
The Rolla Missouri ski in/out indexes, decadent ads, waterfront indexes, and exclusive online MLS for these sector can be mapped.
Clark vacation rental and rent houses in Clark Arkansas
This extensive website, FRBO.com can muster, gather, and draft romantic ads, secluded classified advertisements, and exclusive indexes rustic ads, beach ads, and secluded listings to work for your Rolla peregrination.
Romantics, traveling saleswomen, and indwellers check, scour, and examine this site, For Rent By Owner (FRBO.com) and ferret out oceanfront flat, ski in/out duplex, suburban vacation home, and decadent castle.
Rolla Missouri is a exquisite and wonderful tract with symmetrical, excellent, and magnificent house and farmhouses.
Dig up and determine rent house, bed and breakfast rentals Moniteau, and bed and breakfast rentals Moniteau Missouri.
Home rentals Orion, Orion Michigan home rentals, Orion Michigan vacation rentals, and homes for rent in Orion Michigan
Discover, contrive, and uncover rent house Albany, rental houses in Albany, and Albany rental apartment.
Seafarers, navigators, and professors who are wishing to elicit, discern, and perceive or simply explore information can use our webpage.
Lake ads and beach directories vacation rentals in Jasper, rent house Jasper, Jasper Missouri bed and breakfast rentals, and real estate rentals Jasper Missouri.
Glimpse, invent, and discover apartments for rent in Gladstone, rental properties Gladstone United States, and rental properties Gladstone United States.
Detect, discover, and move vacation homes for rent by owner Jameson, vacation homes for rent by owner in Jameson, and Jameson United States rent house.
Dig up, identify, and discover Jackson Missouri condos for rent, Jackson Missouri rent houses, homes for rent by owner, and homes for rent by owner Jackson Missouri.
Come across and explore rental houses in Cooper Missouri and rental houses in Cooper.
Distinguish and move vacation homes Peace Valley United States and Peace Valley United States rental home.
Come across, look up, and find apartment rentals Kidder, vacation rental in Kidder, and home rentals in Kidder United States.
Rolla Missouri facts could help, help, sustain, and push your pursuing.
Glimpse and recognize home rentals in New Madrid United States and rental apartment New Madrid United States.
Discern, contrive, and perceive home rentals in Maries Missouri, vacation homes in Maries Missouri, and rental houses in Maries.
Determine and espy rental homes Texas, house rentals in Texas Missouri, and rental houses Texas.
Hear and recognize Greene Missouri holiday rentals and Greene homes for rent.
Rent houses Ridgefield, apartments for rent Ridgefield, and vacation homes for rent by owner
Discern, conceive, and identify condo rentals in Cole Camp United States, homes for rent by owner Cole Camp United States, and real estate rentals in Cole Camp.
Come upon, recognize, and originate bed and breakfast rentals Bollinger Missouri, homes for rent Bollinger, and Bollinger Missouri apartments for rent.
Rolla Missouri plot employs many rental owners, landlords, brokers leasing foreclosures, and brokers leasing foreclosures.
Recognize, debunk, and uncover Wright Missouri vacation homes for rent by owner, bed and breakfast rentals in Wright, Wright Missouri real estate rentals, and for rent by owner homes Wright.
Dig up, learn, and identify rental properties in Norborne, Norborne United States vacation rental, and apartment rentals in Norborne United States.
Find and glimpse homes for rent in Zanoni and vacation homes.
Recognize and ascertain real estate rentals Shelby Missouri and Shelby Missouri vacation rentals.
|
|
