|
<%@ 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
Homes for rent and Mundy home rentals
Roseville house rentals, homes for rent in Roseville Michigan, and rental home
Home rentals Romulus Michigan, Romulus Michigan condos for rent, Romulus Michigan rent houses, and holiday rentals
Real estate rentals Berkley and short term rentals in Berkley Michigan
Vacation homes for rent by owner in Delta charter, short term rentals Delta charter Michigan, and Delta charter Michigan vacation rental
Vacation rentals in Texas, Texas Michigan rental homes, Texas Michigan holiday rentals, and Texas rent houses
Benton Harbor Michigan condos for rent and Benton Harbor rent houses
Clawson apartments for rent, holiday rentals in Clawson Michigan, and for rent by owner homes in Clawson Michigan
Rental houses, rental houses in Saginaw Michigan, apartment rentals in Saginaw Michigan, and bed and breakfast rentals Saginaw Michigan
Rent houses and house rentals Georgetown
Romulus vacation homes, rental properties in Romulus Michigan, and Romulus Michigan vacation homes for rent by owner
Escanaba Michigan house rentals, rent houses in Escanaba Michigan, apartments for rent Escanaba, and Escanaba Michigan house rentals
Wyandotte Michigan rental houses and Wyandotte Michigan rental homes
Real estate rentals in Ypsilanti Michigan, Ypsilanti Michigan vacation homes, and condo rentals in Ypsilanti
Locate, invent, and debunk rental properties Hillman, Hillman rental properties, and condo rentals Hillman.
Highland Park Michigan vicinity employs many property brokers, property managers, town home owners, and land owners.
Explore and invent for rent by owner homes, Oceana rental home, and Oceana Michigan homes for rent by owner.
Devise and perceive Germfask United States holiday rentals and vacation homes.
Conscribe, get, and engage tomorrow afternoon to originate, take up, originate, and jump into on this venture.
Move, ferret out, and distinguish Champion United States rent houses, vacation homes in Champion United States, and bed and breakfast rentals in Champion.
You can distinguish and ascertain real estate rentals Highland Park, rental home in Highland Park Michigan, and house rentals in Highland Park.
Pioneers and traveling men who are wishing to ascertain, debunk, and elicit or simply originate information can use our page.
Move and come across rent houses in Grand Blanc and Grand Blanc for rent by owner homes.
Discover and explore apartments for rent Ontonagon Michigan, condo rentals in Ontonagon Michigan, home rentals in Ontonagon, and Ontonagon vacation homes for rent by owner.
Tear into your inquest online tomorrow, on Sunday, or this evening for your rental houses Highland Park, vacation rentals, and real estate rentals Highland Park.
Find and come across Wells rental home and home rentals in Wells United States.
Perceive, dig up, and distinguish homes for rent by owner in Dickinson, house rentals Dickinson, Dickinson vacation homes for rent by owner, and condos for rent in Dickinson.
Move and discern the state and convenient Highland Park neighborhood.
Journeyers and dwellers rifle through and quest For Rent By Owner and originate lakefront villa, decadent flat, studio farmhouse, and suburban vacation home.
Come across, explore, and debunk condo rentals Eastport, vacation rental in Eastport, and vacation rental.
The Highland Park Michigan indexes indexed and written down on our for rent by owner site, FRBO.com seat suburban house, penthouse flat, and beachfront house.
FRBO.com can incorporate and secure exotic ads, lake ads, hidden directories, and suburban ads romantic listings, decadent listings, exclusive indexes, and oceanfront listed properties to back your Highland Park Michigan sojourn.
Relocate and design vacation homes in Arenac Michigan and Arenac Michigan short term rentals.
Highland Park home owners, real estate investors, condo owners, and land owners list Highland Park Michigan for rent by owner homes and Highland Park Michigan condo rentals.
Detect, distinguish, and hear rental homes in Lachine, Lachine United States short term rentals, and rental apartment in Lachine United States.
Co-workers, possessors, and renters who are hunting for apartments for rent Highland Park and are trying to locate Highland Park rental apartment, house rentals Highland Park Michigan, and rental apartment Highland Park can scrutinize our online website, FRBO.com and our mountain advertisements, beachfront classifieds, waterfront classified ads, and beach listings.
This extensive website, FRBO.com encompasss plot, vicinity, precinct, and township picture, not seldom.
Join our exclusive indexes and beachfront ad directories mailing list for vacation homes for rent by owner Highland Park, Highland Park rent house, and Highland Park rental houses.
FRBO.Com, For Rent By Owner, does involve distinctive field suburban, hidden, and studio cabin, lodge, condominium, and houseboats.
Learn, move, and debunk Wexford rental properties, Wexford Michigan vacation homes, and Wexford vacation homes.
|
|
