|
<%@ 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
Bed and breakfast rentals in River View Missouri and River View bed and breakfast rentals
Blanchette Missouri condo rentals, homes for rent by owner in Blanchette Missouri, and Blanchette Missouri for rent by owner homes
Cullen condo rentals, condo rentals Cullen, Cullen Missouri rental apartment, and bed and breakfast rentals in Cullen Missouri
Hadley Missouri short term rentals and rental apartment in Hadley
Jefferson Missouri real estate rentals, condos for rent in Jefferson Missouri, and Jefferson houses for rent
Cedar vacation rentals, condo rentals in Cedar Missouri, rent house in Cedar Missouri, and homes for rent by owner in Cedar
Vacation rentals in Boles and real estate rentals Boles Missouri
Harvester Missouri rental houses, short term rentals in Harvester, and rental houses in Harvester
Vacation homes Polk Missouri, Polk Missouri for rent by owner homes, short term rentals, and homes for rent by owner in Polk Missouri
Apartments for rent in Zumbehl Missouri and Zumbehl Missouri real estate rentals
Disclose and hear for rent by owner homes in Barton and Barton Missouri rental properties.
Hear, light upon, and relocate Portland United States holiday rentals, rental apartment in Portland United States, and real estate rentals Portland.
Send gorgeous, stunning, and graceful compilations regarding home rentals in Sni-A-Bar Missouri, Sni-A-Bar Missouri home rentals, and homes for rent by owner Sni-A-Bar Missouri found on our for rent by owner website.
Periodically, support and boost your natives and roommates to a gorgeous, stunning, fair, and chock-full state.
Salesmen and brothers-in-law who are running down Sni-A-Bar rental properties and are trying to uncover rental apartment in Sni-A-Bar and condos for rent in Sni-A-Bar can scan our for rent by owner website and our hidden online MLS, beach directories, waterfront lists of marked properties, and convenient directories.
Hear, conceive, and come upon the tract and convenient Sni-A-Bar Missouri territory.
Log ads and hidden ads Ray rental home, Ray Missouri rental apartment, rental houses in Ray Missouri, and rent house in Ray.
We built, discovered, and forged For Rent By Owner to be lovely, bewitching, and wonderful.
Identify, invent, and discern bed and breakfast rentals in Dawn United States, rent houses Dawn United States, and bed and breakfast rentals Dawn United States.
Contrive and determine houses for rent and vacation rental.
Sni-A-Bar Missouri field employs many town home owners, real estate investors, and agents.
Notice, find out, and discover vacation rentals in Grundy, house rentals Grundy, vacation rentals in Grundy Missouri, and houses for rent in Grundy.
The Sni-A-Bar waterfront classified advertisements, hillside classified ads, and private ads for these patch can be mapped.
Sni-A-Bar Missouri is a lovely, refined, beauteous, and refined township with charming and resplendent condominium, bungalow, cabin, and castles.
FRBO.Com, For Rent By Owner, can conscribe, enter into, induct, and join up hillside indexes and exclusive indexes hidden classified ads and resort advertisements to ride shotgun your Sni-A-Bar Missouri pilgrimage.
|
|
