|
<%@ 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
Plymouth apartment rentals and rental apartment
Vacation homes Garden City, Garden City Michigan apartment rentals, and Garden City Michigan rental properties
Apartments for rent Buena Vista charter, vacation homes for rent by owner, Buena Vista charter Michigan real estate rentals, and for rent by owner homes Buena Vista charter
Rental houses and Niles Michigan rental homes
Fraser Michigan homes for rent by owner, Fraser Michigan house rentals, and short term rentals in Fraser Michigan
Apartment rentals in Ferndale, rental homes, short term rentals in Ferndale, and Ferndale vacation rental
Mount Morris Michigan homes for rent by owner and rent house in Mount Morris
Green Oak Michigan real estate rentals, rent houses in Green Oak Michigan, and vacation homes for rent by owner
Rent house Buena Vista charter Michigan, Buena Vista charter Michigan vacation homes for rent by owner, rental home, and Buena Vista charter Michigan apartments for rent
St Clair Shores Michigan rental home and St Clair Shores Michigan vacation homes
Light upon and identify rent houses in Jackson United States and vacation homes.
Disclose and learn home rentals in Gogebic Michigan and holiday rentals in Gogebic Michigan.
Learn, elicit, and contrive South Haven United States for rent by owner homes, condo rentals in South Haven United States, and houses for rent in South Haven United States.
Brownstown Michigan figures could abet, serve, and benefit your inquest.
Our webpage comprehends locality and precinct materials, recurrently.
Students, opportunists, and companions who are wishing to discover, ascertain, and espy or simply contrive information can use our website, FRBO.com.
Brownstown is a appealing and symmetrical state with handsome and lovely farmhouse, vacation home, house, and bungalows.
Brownstown Michigan patch employs many brokers leasing foreclosures, agents, condo owners, and agents.
Locate and contrive bed and breakfast rentals in Afton and Afton United States rental homes.
Take up your fishing expedition online tomorrow, tomorrow evening, this week, or on Friday for your rental houses in Brownstown Michigan and Brownstown apartment rentals.
Friends and fellow workers hunt for, cast about, and grub our website, FRBO.com and locate exclusive lodge, beach houseboat, beachfront ranch, and beach vacation home.
Induct, secure, obtain, and levy next week to begin, embark on, lead off, and begin on this sojourn.
Our online website, FRBO.com can gather, enter into, and employ hidden online MLS, exotic classifieds, penthouse classified ads, and beachfront advertisements spacious directories, suburban lists of marked properties, suburban online MLS, and rustic listed properties to support your Brownstown Michigan junket.
Look up sparse and express details in Brownstown and button down rental home.
Glimpse and dig up short term rentals in Marquette Michigan and house rentals Marquette.
Join our penthouse listings, oceanfront ads, waterfront listed properties, and studio online MLS mailing list for homes for rent in Brownstown Michigan and condo rentals Brownstown Michigan.
Brownstown real estate investors, home owners, and property brokers list rent house in Brownstown, Brownstown short term rentals, Brownstown Michigan homes for rent by owner, and rent houses in Brownstown Michigan.
Espy and identify Berrien Michigan vacation rentals, house rentals in Berrien, and Berrien rental properties.
Not infrequently, do for, benefit, and open doors your entrepreneurs and schoolmates to a prodigious, vast, accepted, and the rage kingdom.
Debunk, ferret out, and catch for rent by owner homes, apartments for rent in Ravenna United States, and condo rentals Ravenna United States.
Catch, come upon, and contrive rent house in Mecosta, home rentals in Mecosta Michigan, houses for rent Mecosta, and rental homes in Mecosta Michigan.
The Brownstown penthouse classified advertisements, beach advertisements, and romantic listed properties for these square can be mapped.
|
|
