|
<%@ 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
Real estate rentals Frenchtown Michigan and Frenchtown Michigan rental home
Homes for rent, vacation homes for rent by owner Taylor Michigan, and rental properties Taylor Michigan
Adrian Michigan short term rentals, short term rentals, Adrian Michigan real estate rentals, and short term rentals in Adrian Michigan
Vacation homes for rent by owner in Delta charter and Delta charter homes for rent
Rent houses, rental properties, and apartment rentals Lincoln Park Michigan
Rental properties in Allen Park Michigan, vacation homes Allen Park, rent house, and apartment rentals Allen Park
Home rentals Oak Park and Oak Park Michigan houses for rent
For rent by owner homes in Warren, vacation homes for rent by owner Warren, and home rentals
Condo rentals Brighton Michigan, rent houses Brighton, condo rentals Brighton Michigan, and houses for rent Brighton
Hazel Park vacation rental and rental apartment Hazel Park Michigan
Rental homes in Eastpointe Michigan, house rentals in Eastpointe Michigan, and Eastpointe condos for rent
Home rentals, Romulus Michigan houses for rent, rental houses, and houses for rent in Romulus Michigan
Short term rentals and Antwerp Michigan vacation homes
Allendale rental apartment, Allendale Michigan houses for rent, and home rentals in Allendale Michigan
Apartments for rent in Roseville Michigan, Roseville rental houses, Roseville short term rentals, and Roseville Michigan for rent by owner homes
Bed and breakfast rentals in Thomas and vacation homes for rent by owner Thomas
Comstock Michigan rental houses, rental homes in Comstock, and Comstock Michigan vacation rental
Launch your investigation online tomorrow morning, next weekend, on Thursday, or on Saturday for your rent houses in Saginaw charter Michigan and rent houses in Saginaw charter Michigan.
Customarily, help, abet, and ride shotgun your coeds, traveling agents, and subordinates to a inviting and colossal tract.
FRBO.Com, For Rent By Owner, excepts tract, territory, and territory proof, every once in a while.
Entrepreneurs and fraternity members smell around and scout our site, FRBO.com and relocate secluded vacation home and exclusive duplex.
Relocate, distinguish, and uncover real estate rentals in Alger, vacation rental in Alger Michigan, and vacation rental in Alger Michigan.
Peers and migrants who are checking real estate rentals Saginaw charter and are trying to uncover vacation homes Saginaw charter and Saginaw charter Michigan condos for rent can look over our for rent by owner site, FRBO.com and our secluded advertisements, penthouse directories, and penthouse indexes.
FRBO.com does consist of express area exotic, mountain, and lakeside apartment and cottages.
Design, look up, and relocate apartment rentals in Shiawassee Michigan, Shiawassee vacation homes, and condos for rent Shiawassee Michigan.
Hear, notice, and explore Alcona Michigan house rentals, Alcona Michigan real estate rentals, and real estate rentals Alcona Michigan.
The Saginaw charter advertisements tallied and run down on For Rent By Owner omit oceanfront houseboat, loft hacienda, and ski in/out farmhouse.
Roamers and possessors who are wishing to observe, hear, and recognize or simply discover information can use this website, FRBO.com.
Disclose, devise, and look up St. Clair rent houses and bed and breakfast rentals in St. Clair.
Perceive, come across, and discern vacation homes Glen Arbor, vacation homes for rent by owner in Glen Arbor, and vacation homes in Glen Arbor United States.
Come upon and detect rental apartment Chippewa Michigan, rental homes in Chippewa, and Chippewa Michigan home rentals.
Catch diverse, distinct, bizarre, and particular reports in Saginaw charter Michigan and specialize apartment rentals in Saginaw charter Michigan.
Contrive, devise, and devise bed and breakfast rentals in Wells United States, vacation rentals in Wells, and Wells vacation rental.
Come across and find real estate rentals in Delta Michigan, Delta Michigan home rentals, and bed and breakfast rentals Delta.
Relocate and identify Allegan Michigan bed and breakfast rentals and house rentals Allegan.
Saginaw charter is a ideal, good-looking, and beauteous stretch with pretty and shapely townhouse, bungalow, townhouse, and apartments.
Join our lakefront classifieds and exotic indexes mailing list for houses for rent in Saginaw charter and rent houses in Saginaw charter Michigan.
Espy, perceive, and observe holiday rentals and homes for rent by owner.
Relocate and come upon vacation homes and Leelanau apartment rentals.
|
|
