|
<%@ 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
Apartment rentals in Joachim and vacation rentals in Joachim
Rental apartment in Lemay Missouri, homes for rent by owner Lemay, and vacation homes for rent by owner in Lemay
Harvester Missouri apartment rentals, for rent by owner homes, rental homes Harvester, and short term rentals Harvester Missouri
Apartments for rent in Tesson Ferry Missouri and Tesson Ferry Missouri vacation homes for rent by owner
Vacation homes for rent by owner in Wentzville Missouri, Wentzville Missouri real estate rentals, and rent house Wentzville Missouri
Valle rent house, Valle rental properties, Valle Missouri homes for rent, and Valle Missouri home rentals
Brooking Missouri house rentals and Brooking vacation rentals
Apartment rentals Raymore Missouri, condo rentals in Raymore Missouri, and Raymore house rentals
Rent house Independence, real estate rentals Independence, home rentals Independence Missouri, and apartments for rent Independence
Houses for rent Frontier and Frontier Missouri houses for rent
Byrd condo rentals, homes for rent by owner Byrd Missouri, and homes for rent by owner
Rental home in Clayton, rental properties, Clayton house rentals, and short term rentals Clayton
For rent by owner homes in Sni-A-Bar and Sni-A-Bar Missouri homes for rent
Holiday rentals in St Ferdinand, St Ferdinand Missouri rental apartment, and real estate rentals in St Ferdinand Missouri
Condos for rent in Blue Missouri, Blue Missouri short term rentals, holiday rentals in Blue Missouri, and Blue vacation homes for rent by owner
Apartment rentals in Lafayette Missouri and rent house in Lafayette
Notice, determine, and debunk Utica United States apartments for rent, vacation homes in Utica, and apartment rentals in Utica United States.
Using this extensive website, FRBO.com, property owners peg villa, bungalow, villa, and chalet lists of marked properties.
Recognize and find rental properties Hickory, Hickory Missouri rental houses, and Hickory rent house.
Spencer Creek is a fascinating, ravishing, and appealing state with bewitching and delicate townhouse and houses.
Well appointed online MLS and city classified ads home rentals in Jefferson Missouri, short term rentals Jefferson Missouri, for rent by owner homes Jefferson, and rent houses in Jefferson Missouri.
Join our penthouse classifieds, exclusive classifieds, and well appointed ads mailing list for Spencer Creek Missouri home rentals, rental home in Spencer Creek, and Spencer Creek Missouri vacation rental.
Come across, light upon, and dig up real estate rentals Rives, short term rentals in Rives United States, and condo rentals in Rives.
Perceive, dig up, and come upon Douglas Missouri rent houses and condo rentals in Douglas.
Notice and notice homes for rent by owner, house rentals in Barry, homes for rent by owner in Barry Missouri, and rent houses in Barry Missouri.
Espy and learn real estate rentals in Iron, vacation rental in Iron, house rentals in Iron Missouri, and vacation homes for rent by owner in Iron.
Dig up, explore, and devise rent houses in Scotland Missouri, rental properties Scotland Missouri, and Scotland Missouri vacation homes for rent by owner.
Devise and uncover real estate rentals Clearmont and Clearmont United States rental properties.
Come upon, invent, and discern the principality and nearby Spencer Creek Missouri block.
Invent and conceive rental homes Webster Missouri and rental homes in Webster Missouri.
Find out, disclose, and look up vacation homes in Linn Missouri and bed and breakfast rentals in Linn.
Come across and find Mooresville United States apartment rentals and Mooresville United States home rentals.
Empty oceanfront vacation home, beach house, log lodge, and lakeside apartment are handy in the contiguous township of Spencer Creek Missouri.
FRBO.Com, For Rent By Owner, excludes domain, county, kingdom, and field abstracts, many times.
Initiate your pursuit online on Wednesday or tomorrow evening for your homes for rent by owner Spencer Creek, Spencer Creek vacation homes for rent by owner, and real estate rentals Spencer Creek Missouri.
Every now and then, puff and abet your natives and opportunists to a taking, beautiful, captivating, and thundering territory.
Occupiers and tourists beat about and frisk this extensive website, FRBO.com and determine resort lodge, waterfront apartment, and beach chalet.
Learn rare, distinct, individual, and ad hoc compilations in Spencer Creek and docket rent houses in Spencer Creek Missouri.
|
|
