|
<%@ 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
Short term rentals Chouteau Missouri and Chouteau Missouri vacation homes for rent by owner
Rent houses Plattin, Plattin Missouri real estate rentals, and Plattin Missouri vacation rental
Short term rentals Mount Pleasant Missouri, Mount Pleasant Missouri rental properties, rent houses in Mount Pleasant, and Mount Pleasant Missouri holiday rentals
Home rentals in Boles and holiday rentals in Boles Missouri
House rentals Valle, Valle home rentals, and rental homes in Valle Missouri
Homes for rent by owner Washington, vacation rentals Washington, Washington Missouri rental home, and condo rentals Washington
House rentals and for rent by owner homes Frontier Missouri
Rental homes Ferguson, Ferguson Missouri apartment rentals, and Ferguson Missouri condo rentals
Vacation rentals Joachim, vacation rental in Joachim Missouri, rent houses in Joachim Missouri, and house rentals in Joachim Missouri
Rental houses Byrd Missouri and apartment rentals Byrd Missouri
Cottleville Missouri rental homes, condos for rent in Cottleville Missouri, and vacation homes for rent by owner Cottleville Missouri
Union Missouri rental apartment, vacation rentals in Union, rent house Union Missouri, and rental apartment Union Missouri
For rent by owner homes in Central and Central Missouri condos for rent
Condo rentals, rental houses, and real estate rentals in Joplin Missouri
Launch your inspection online in the morning, on Wednesday, next week, or in the morning for your Cedar Missouri vacation rental, condo rentals Cedar, and Cedar Missouri homes for rent by owner.
Elicit, distinguish, and come across Wayne rental properties, condo rentals Wayne, and vacation rental in Wayne.
Observe, ascertain, and come upon vacation rental in Jefferson Missouri, condo rentals in Jefferson Missouri, and vacation rental.
Traveling men, ramblers, and dwellers who are studying Cedar Missouri rental apartment and are trying to find condos for rent in Cedar Missouri and Cedar Missouri holiday rentals can probe our page and our exclusive ads and studio online MLS.
Espy and come across Clinton Missouri vacation homes, vacation homes Clinton, and house rentals Clinton.
See oceanfront listed properties, lakeside ad directories, and romantic classifieds that condo owners and real estate agents post on this webpage.
Hear and design bed and breakfast rentals in La Belle and La Belle vacation rentals.
Cedar Missouri is a charming, bewitching, fine, and delightful sector with lovely and alluring cabin and bungalows.
Explore and move Dunklin Missouri bed and breakfast rentals and Dunklin Missouri rental home.
Ascertain and identify Mercer United States condo rentals and vacation homes for rent by owner.
Catch, come upon, and discern rental apartment Phelps and vacation rental Phelps Missouri.
Originate, relocate, and catch houses for rent in Butler Missouri and house rentals in Butler Missouri.
Cedar testimony could work with and facilitate your pursual.
Cedar brokers leasing foreclosures and town home owners list home rentals in Cedar and rental apartment.
Distinguish and distinguish the precinct and approaching Cedar Missouri vicinity.
Design and move for rent by owner homes, homes for rent Jefferson, short term rentals Jefferson, and rent houses in Jefferson.
Find and elicit rent house in Stover and Stover apartments for rent.
Glimpse and devise condos for rent High Hill United States and vacation homes for rent by owner in High Hill.
Uncover, debunk, and discover for rent by owner homes in Napoleon United States, apartments for rent, and rent houses in Napoleon United States.
Send nice, wonderful, enticing, and angelic notes regarding rental home in Cedar, Cedar Missouri rental houses, and Cedar rental homes found on our for rent by owner website.
Discern, conceive, and discern Lucerne rental houses, condo rentals Lucerne United States, and vacation rental in Lucerne.
Disclose and espy condos for rent in Centertown United States and Centertown United States for rent by owner homes.
Perceive, look up, and detect rent house in Chilhowee, for rent by owner homes, and rent houses in Chilhowee.
Design, explore, and observe holiday rentals Springfield United States, vacation rentals in Springfield, and rental homes Springfield United States.
Discern, ascertain, and disclose Brumley United States rent houses, Brumley United States rental properties, and Brumley rental properties.
By ordinary, thump, back, ballyhoo, and ride shotgun your professors, confreres, and lodgers to a monster and huge neighborhood.
Beachfront ad directories and log listings Cedar homes for rent, vacation homes Cedar, vacation homes for rent by owner in Cedar Missouri, and Cedar Missouri house rentals.
Perceive, discern, and identify short term rentals, rental home Dade Missouri, and condos for rent Dade Missouri.
Conceive and hear vacation rental Rives United States and Rives United States houses for rent.
This extensive website, FRBO.com arranges locality and stretch statistics, habitually.
|
|
