|
<%@ 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
Houses for rent and rental apartment in Riverview Michigan
Vacation rental in Redford, vacation rental Redford, and short term rentals Redford Michigan
Rochester Michigan houses for rent, holiday rentals Rochester Michigan, bed and breakfast rentals Rochester Michigan, and Rochester vacation rental
Homes for rent by owner Oak Park Michigan and bed and breakfast rentals Oak Park
Vacation rental, vacation homes for rent by owner in Fenton Michigan, and short term rentals Fenton
Grand Blanc Michigan condos for rent, vacation homes Grand Blanc, Grand Blanc Michigan homes for rent by owner, and rental home
Farmington Hills vacation homes and Farmington Hills short term rentals
Southfield Michigan rental apartment, rent houses in Southfield Michigan, and Southfield Michigan houses for rent
Scio house rentals, rental apartment Scio, rental properties in Scio Michigan, and Scio Michigan condo rentals
Vacation rental Fort Gratiot Michigan and bed and breakfast rentals Fort Gratiot Michigan
Homes for rent by owner Genoa Michigan, rental apartment Genoa Michigan, and Genoa Michigan apartments for rent
Milford holiday rentals, house rentals Milford, rent house, and holiday rentals Milford
Apartment rentals in Southgate Michigan and Southgate Michigan house rentals
Rent houses in Midland Michigan, short term rentals Midland, and Midland house rentals
Lincoln charter homes for rent by owner, home rentals in Lincoln charter, rental home, and real estate rentals Lincoln charter Michigan
Ferndale Michigan condo rentals and house rentals
Bed and breakfast rentals, bed and breakfast rentals Escanaba, and Escanaba Michigan vacation homes for rent by owner
Ferret out and espy vacation rentals Baroda United States and for rent by owner homes in Baroda United States.
Invent and come across for rent by owner homes in Roscommon United States and Roscommon rental apartment.
Emmett Michigan neighborhood employs many real estate investors, real estate investors, property owners, and agents serving the condo market.
Hear and conceive house rentals and Hessel homes for rent.
Come across and catch rental apartment in Sanford United States and apartments for rent.
Determine, notice, and espy short term rentals in Somerset Center United States, rental homes in Somerset Center, and apartments for rent.
Emmett agents serving the condo market and property brokers list Emmett Michigan for rent by owner homes, homes for rent, and vacation rental.
Discover, discern, and identify rental houses in Curran United States, rental houses in Curran, and holiday rentals in Curran United States.
Perceive and contrive bed and breakfast rentals Eaton and rent house in Eaton.
Ferret out, look up, and discern rental home Gladwin Michigan and Gladwin Michigan condo rentals.
Determine, catch, and ascertain vacation homes for rent by owner and Oakland Michigan rental apartment.
Trippers, peers, and occupiers who are wishing to locate and locate or simply uncover information can use FRBO.com.
Discover and find out Leelanau Michigan apartment rentals, short term rentals Leelanau Michigan, Leelanau Michigan rental home, and Leelanau Michigan vacation rentals.
Bedmates and transmigrants who are poking into for rent by owner homes in Emmett Michigan and are trying to learn Emmett Michigan house rentals and real estate rentals in Emmett Michigan can poke into this extensive website, FRBO.com and our hidden ad directories, penthouse listings, exclusive ad directories, and penthouse online MLS.
See lake online MLS, suburban classified ads, and exclusive classified advertisements that condo owners and condo owners post on this website, FRBO.com.
Come across, glimpse, and invent for rent by owner homes in Naubinway, Naubinway United States rental apartment, and vacation homes for rent by owner Naubinway.
Our page excepts vicinity, field, quarter, and domain figures, at times.
Find and distinguish Emmet rent house and real estate rentals in Emmet Michigan.
Uncover and come upon rental houses Conklin United States and rental homes in Conklin.
The Emmett Michigan hillside lists of marked properties and hidden lists of marked properties for these square can be mapped.
FRBO.Com, For Rent By Owner, does arrange another story square studio and beach duplex and houseboats.
Disclose, determine, and devise real estate rentals Washington, Washington United States apartment rentals, and homes for rent by owner in Washington United States.
Disclose, determine, and espy homes for rent in Dansville, Dansville United States houses for rent, and rental home in Dansville.
|
|
