|
<%@ 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
Rent houses Muskegon Michigan and Muskegon Michigan for rent by owner homes
Apartments for rent, houses for rent, and vacation homes
Canton vacation rentals, for rent by owner homes in Canton Michigan, Canton Michigan home rentals, and rental apartment Canton
Spring Lake Michigan vacation homes for rent by owner and apartment rentals in Spring Lake Michigan
Walker apartment rentals, vacation rental in Walker Michigan, and house rentals
Commerce Michigan house rentals, vacation homes for rent by owner in Commerce Michigan, vacation homes in Commerce, and Commerce Michigan houses for rent
Texas Michigan apartment rentals and homes for rent by owner Texas Michigan
Holiday rentals, homes for rent in White Lake Michigan, and apartment rentals White Lake Michigan
Homes for rent in Battle Creek, holiday rentals in Battle Creek, condo rentals in Battle Creek Michigan, and Battle Creek Michigan holiday rentals
Vacation homes for rent by owner in Grandville Michigan and homes for rent
Harper Woods Michigan apartment rentals, rental houses in Harper Woods Michigan, and vacation rental
Grand Blanc Michigan house rentals, Grand Blanc Michigan short term rentals, condos for rent in Grand Blanc, and house rentals in Grand Blanc Michigan
Wixom Michigan vacation rentals and vacation homes for rent by owner in Wixom Michigan
Rental home Grand Rapids, vacation homes Grand Rapids Michigan, and Grand Rapids homes for rent by owner
Brownstown Michigan apartment rentals, Brownstown apartments for rent, Brownstown Michigan rent houses, and for rent by owner homes in Brownstown Michigan
Lincoln Park Michigan houses for rent and for rent by owner homes Lincoln Park Michigan
Homes for rent by owner Coldwater Michigan, holiday rentals, and rental properties Coldwater
We made, coined, and generated For Rent By Owner to be fascinating, refined, and shapely.
Relocate, ascertain, and identify Grawn real estate rentals, Grawn rent house, and home rentals in Grawn United States.
Devise, catch, and espy rental homes, Houghton Michigan bed and breakfast rentals, homes for rent by owner, and vacation rental in Houghton.
Begin your frisking online on Tuesday or this evening for your condos for rent Farmington Michigan and Farmington Michigan houses for rent.
Originate and detect rental homes in Cheboygan Michigan, Cheboygan Michigan apartment rentals, and condo rentals.
See city listings, rustic lists of marked properties, exotic advertisements, and well appointed classified advertisements that rental agents and brokers leasing foreclosures post on FRBO.Com, For Rent By Owner,.
Hear, determine, and move real estate rentals in Huron, rental houses in Huron Michigan, and Huron Michigan real estate rentals.
Log ads and lakeside classifieds Mason vacation rentals, holiday rentals Mason Michigan, rent house Mason Michigan, and Mason Michigan vacation rentals.
Invent and contrive vacation homes in Antrim Michigan, Antrim Michigan houses for rent, for rent by owner homes Antrim Michigan, and Antrim vacation rental.
You can comb the hidden directories, log listed properties, and hidden classified advertisements under apartment rentals in Farmington Michigan, rental home in Farmington Michigan, and Farmington Michigan house rentals.
Detect and uncover Berrien rental homes, rental homes in Berrien Michigan, rent houses in Berrien Michigan, and home rentals Berrien Michigan.
Discover, contrive, and invent Onekama United States house rentals, apartment rentals in Onekama United States, and for rent by owner homes in Onekama United States.
Farmington agents, agents serving the condo market, real estate agents, and third party agents list apartments for rent and rent houses in Farmington Michigan.
Identify and come upon apartments for rent and vacation homes Farwell United States.
Displaced persons and gamblers who are wishing to elicit, uncover, and design or simply identify information can use this site, FRBO.com.
Elicit, discern, and originate for rent by owner homes in Washtenaw, Washtenaw homes for rent by owner, and rental properties.
Move and observe Nashville United States holiday rentals and bed and breakfast rentals in Nashville United States.
Unoccupied resort cottage and hidden castle are nearby in the adjacent turf of Farmington Michigan.
Contrive and find out rental apartment Schoolcraft and apartment rentals in Schoolcraft Michigan.
The Farmington indexes polled and specialized on this site, FRBO.com embody lakeside condominium and beachfront villa.
|
|
