|
<%@ 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" %>
|
Michigan Rental Links
Rental home in Green Oak and Green Oak real estate rentals
Ecorse Michigan houses for rent, vacation rental in Ecorse, and rental properties
Home rentals in Ferndale, rent houses in Ferndale Michigan, Ferndale Michigan apartment rentals, and Ferndale Michigan rental apartment
Condo rentals Fenton and rental homes
Vacation rental in Novi, holiday rentals Novi, and vacation rentals
Vacation homes, vacation homes Eastpointe, Eastpointe Michigan rental homes, and Eastpointe rental home
Oakland charter Michigan rental properties and Oakland charter Michigan rent house
Condos for rent, vacation homes Brandon, and bed and breakfast rentals Brandon
Rental home in Niles, rental houses in Niles Michigan, houses for rent in Niles Michigan, and condo rentals Niles Michigan
Niles Michigan rental properties and bed and breakfast rentals
Flushing Michigan house rentals, vacation rental Flushing, and Flushing Michigan house rentals
Apartment rentals in Pontiac Michigan, rental houses in Pontiac Michigan, rental home in Pontiac Michigan, and rental properties in Pontiac Michigan
Rental apartment Mundy Michigan and Mundy homes for rent
Trekkers, traveling saleswomen, and romantics run down, inquire, and inquire FRBO.com and locate city lodge, hidden cottage, and hidden castle.
Disclose and find out homes for rent in Cooks United States and houses for rent.
Notice, conceive, and uncover apartment rentals Ridgeway, Ridgeway United States holiday rentals, and Ridgeway United States vacation homes for rent by owner.
Debunk, invent, and locate condo rentals Bay Michigan, rental houses in Bay, and vacation homes for rent by owner.
You can locate, dig up, and glimpse rent houses in Oakland charter and vacation homes for rent by owner in Oakland charter.
Inaugurate your scrutiny online on Wednesday or now for your Oakland charter short term rentals, Oakland charter Michigan apartments for rent, and condos for rent in Oakland charter.
Hitch, gather, and serve on Saturday to kick off and get cracking on this vagabondage.
Debunk and uncover rental properties in Palms United States and Palms United States rental houses.
The Oakland charter Michigan classified advertisements scheduled and kept counted on our page embody hillside townhouse and secluded duplex.
Using this website, FRBO.com, third party agents tab villa, villa, castle, and hacienda classifieds.
Distinguish and recognize home rentals in Gladwin, home rentals in Gladwin, and Gladwin Michigan rental properties.
Catch and detect bed and breakfast rentals Missaukee Michigan and homes for rent by owner in Missaukee Michigan.
Find out, observe, and identify Berkley house rentals, Berkley United States bed and breakfast rentals, and short term rentals.
Oakland charter vicinity employs many property owners, third party agents, brokers leasing foreclosures, and property owners.
Schoolmates, schoolmates, and fellow workers who are questing rental properties Oakland charter Michigan and are trying to find out house rentals in Oakland charter Michigan and apartment rentals in Oakland charter can forage our webpage and our lakefront advertisements, decadent advertisements, hillside indexes, and mountain ads.
|
|
