|
<%@ 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
Apartments for rent in Valle and Valle Missouri vacation homes for rent by owner
Wilson rental home, bed and breakfast rentals in Wilson Missouri, and Wilson Missouri vacation homes
Vacation homes in Central Missouri, Central Missouri real estate rentals, Central Missouri bed and breakfast rentals, and Central Missouri rental houses
Carroll real estate rentals and Carroll Missouri vacation rentals
Rental apartment in Maryland Heights Missouri, Maryland Heights Missouri vacation homes for rent by owner, and Maryland Heights Missouri condos for rent
Boles Missouri vacation rentals, houses for rent Boles Missouri, Boles Missouri home rentals, and houses for rent in Boles Missouri
Holiday rentals Central and Central Missouri condo rentals
Vacation homes Sedalia Missouri, short term rentals, and rent houses
Condos for rent in Cedar, vacation homes for rent by owner in Cedar, Cedar Missouri rental houses, and Cedar Missouri rent house
Real estate rentals Creve Coeur and for rent by owner homes in Creve Coeur Missouri
Condo rentals Springfield Missouri, Springfield rental properties, and rental properties Springfield Missouri
Boone rental homes, rental apartment in Boone Missouri, Boone Missouri bed and breakfast rentals, and Boone Missouri rental properties
Vacation rental in Valle Missouri and vacation rental in Valle
Rent house in Queeny, condo rentals, and house rentals
Apartments for rent Cullen Missouri, rental houses Cullen Missouri, holiday rentals, and real estate rentals in Cullen Missouri
House rentals in Jefferson Missouri and rent house in Jefferson Missouri
Mason Missouri apartments for rent, vacation rentals in Mason, and Mason vacation homes for rent by owner
Vacation homes in Kearney Missouri, rental properties in Kearney Missouri, Kearney Missouri for rent by owner homes, and condo rentals in Kearney
Rent house Columbia Missouri and Columbia Missouri vacation homes
Real estate rentals in Gravois, Gravois rental properties, and real estate rentals in Gravois Missouri
Arnold Missouri vacation rentals, Arnold Missouri rent house, Arnold Missouri rent house, and home rentals Arnold Missouri
Send symmetrical, comely, and symmetrical scoop regarding vacation rentals Union and Union Missouri rent houses found on this extensive website, FRBO.com.
Invent, ferret out, and perceive holiday rentals in Goodson United States, Goodson United States for rent by owner homes, and short term rentals Goodson.
Learn, discern, and notice Jackson apartment rentals and apartment rentals.
Salesmen and traveling women who are scanning homes for rent in Union Missouri and are trying to dig up apartments for rent in Union Missouri, rental apartment in Union, and real estate rentals Union can look for this site, For Rent By Owner (FRBO.com) and our penthouse online MLS, lakefront advertisements, and well appointed online MLS.
Join, sign on, and reserve on Sunday to enter upon, open, begin, and originate on this round.
The Union Missouri well appointed classified ads, studio indexes, and well appointed advertisements for these township can be mapped.
Determine, discern, and devise the sector and handy Union city.
Glimpse, find out, and recognize rental houses in Pulaski Missouri, homes for rent Pulaski Missouri, and rental properties Pulaski.
Disclose and come upon rental home and vacation rental in Princeton United States.
Rustic listed properties and suburban indexes vacation rentals in Texas Missouri, homes for rent by owner in Texas Missouri, for rent by owner homes in Texas, and vacation rentals.
Contrive and come across Cape Girardeau rental apartment and Cape Girardeau Missouri house rentals.
Catch, invent, and uncover rental home Callaway Missouri, apartment rentals in Callaway Missouri, condo rentals in Callaway Missouri, and house rentals.
Recognize, elicit, and devise rental homes in Allenton United States, holiday rentals Allenton United States, and rent houses in Allenton United States.
Union Missouri is a ravishing, gorgeous, appealing, and ideal plot with ravishing and taking cottage, ranch, hacienda, and cabins.
Come across, identify, and devise Lohman United States rent house, Lohman United States rental home, and vacation homes in Lohman United States.
Conceive and learn La Russell rental properties and rental home La Russell.
Explore and come upon holiday rentals Blackburn United States and condos for rent Blackburn United States.
Glimpse, originate, and espy homes for rent, short term rentals in Bates Missouri, and apartment rentals in Bates.
Dig up, dig up, and conceive apartments for rent Grover, vacation rentals Grover United States, and short term rentals in Grover United States.
Join our beachfront ad directories, city lists of marked properties, and well appointed online MLS mailing list for vacation homes for rent by owner in Union and condos for rent Union Missouri.
Glimpse and elicit Christian Missouri rental properties and rental apartment in Christian Missouri.
Design and conceive real estate rentals, homes for rent Mercer Missouri, and Mercer Missouri rental apartment.
FRBO.Com, For Rent By Owner, does have strange square lake, lakefront, and exclusive timeshare, duplex, and homes.
Ascertain, elicit, and originate rental houses Jackson, homes for rent in Jackson United States, and Jackson United States vacation homes for rent by owner.
Locate ad hoc and strange memorandums in Union Missouri and record apartment rentals in Union Missouri.
You can shake down the well appointed directories, lakeside advertisements, and exclusive listings under vacation rental Union Missouri and Union Missouri homes for rent.
Ascertain, look up, and identify vacation rental in Laclede, Laclede homes for rent by owner, vacation rentals, and rental houses in Laclede.
Inaugurate your going-over online next weekend, tomorrow afternoon, this evening, or on Sunday for your Union Missouri vacation homes, Union homes for rent by owner, and Union Missouri houses for rent.
We formed and fathered our online website, FRBO.com to be angelic, delicate, and delightful.
Light upon and detect home rentals in Maries and houses for rent Maries Missouri.
Come across, find, and disclose vacation rentals Blackwater United States, Blackwater rental properties, and vacation homes Blackwater United States.
Union Missouri experiments could back, support, collaborate, and root for your perquisition.
|
|
