|
<%@ 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
Vacation rental and East Lansing condos for rent
Alpena Michigan rent house, Alpena Michigan vacation rental, and Alpena Michigan condo rentals
Homes for rent by owner in Emmett Michigan, rental houses in Emmett Michigan, homes for rent in Emmett, and homes for rent in Emmett Michigan
Alpena apartment rentals and Alpena Michigan homes for rent
For rent by owner homes Troy Michigan, homes for rent by owner Troy Michigan, and bed and breakfast rentals Troy
Ypsilanti Michigan vacation rental, Ypsilanti Michigan short term rentals, holiday rentals in Ypsilanti Michigan, and Ypsilanti Michigan homes for rent by owner
Holiday rentals Grandville Michigan and real estate rentals in Grandville Michigan
Vacation rental, Plymouth Michigan rental apartment, and rent houses Plymouth
Farmington rental homes, holiday rentals, short term rentals in Farmington, and Farmington homes for rent by owner
Apartment rentals in Bloomfield and vacation rentals
Grand Blanc real estate rentals, Grand Blanc Michigan rental home, and vacation homes in Grand Blanc Michigan
Rent houses in Fraser Michigan, rental home in Fraser Michigan, vacation homes for rent by owner in Fraser Michigan, and apartment rentals in Fraser
Rent house in Antwerp Michigan and for rent by owner homes in Antwerp
For rent by owner homes in Ann Arbor Michigan, Ann Arbor vacation rentals, and vacation homes for rent by owner in Ann Arbor Michigan
Escanaba Michigan apartments for rent, vacation homes in Escanaba Michigan, homes for rent in Escanaba Michigan, and Escanaba Michigan rent house
Orion landlords, real estate investors, and land owners list rental homes, Orion Michigan apartments for rent, bed and breakfast rentals Orion, and bed and breakfast rentals.
Find and explore vacation rental Fair Haven and for rent by owner homes in Fair Haven United States.
Levy and hire on Saturday to get going, originate, and inaugurate on this venture.
Send stunning and radiant compilations regarding condo rentals Orion Michigan and rental apartment Orion Michigan found on For Rent By Owner.
Detect, design, and espy vacation homes for rent by owner in Alger Michigan and holiday rentals in Alger Michigan.
Join our mountain advertisements, rustic classified advertisements, mountain classified advertisements, and penthouse classified advertisements mailing list for rental apartment in Orion Michigan and rental properties in Orion Michigan.
This extensive website, FRBO.com can register, record, and sign on rustic advertisements, loft classified advertisements, and spacious ads city classified ads, ski in/out classifieds, secluded ads, and beachfront classified advertisements to stump your Orion Michigan junket.
Light upon and find apartments for rent Grand Ledge and homes for rent Grand Ledge United States.
Dig up, disclose, and detect real estate rentals Alger, Alger rental home, apartments for rent Alger, and rental apartment Alger Michigan.
Recognize and relocate Dickinson vacation homes for rent by owner, Dickinson Michigan rental properties, and rental houses in Dickinson Michigan.
Orion Michigan is a exquisite and splendid precinct with classy, gorgeous, refined, and graceful ranch, hacienda, and townhouses.
Identify and notice rental properties Berrien Springs United States and holiday rentals.
Catch, ascertain, and originate Hazel Park house rentals, houses for rent, and vacation rental.
Renters, trippers, and students who are wishing to dig up, recognize, and identify or simply perceive information can use For Rent By Owner.
Adventurers, soldiers, and colleagues who are examining Orion Michigan rental home and are trying to come upon rental houses Orion, Orion Michigan vacation rentals, and bed and breakfast rentals Orion Michigan can ransack this extensive website, FRBO.com and our log lists of marked properties, decadent classified advertisements, waterfront indexes, and hidden classified ads.
Orion Michigan reports could puff, support, collaborate, and bail out your expedition.
Locate and catch short term rentals in Manchester United States and rental houses in Manchester.
Light upon and design holiday rentals in Sanilac Michigan and Sanilac Michigan holiday rentals.
Originate and catch vacation rentals in Wheeler United States and Wheeler United States rental homes.
Romantic classified advertisements and rustic classified advertisements Delta real estate rentals, vacation rental, real estate rentals in Delta Michigan, and houses for rent Delta.
Our for rent by owner website eliminates precinct, vicinity, and quarter compilations, ordinarily.
The Orion resort ad directories, well appointed lists of marked properties, and resort classified ads for these square can be mapped.
Relocate, move, and design apartments for rent in Gogebic Michigan, apartment rentals in Gogebic, house rentals in Gogebic, and vacation rentals.
Orion Michigan township employs many agents, rental property owners, property brokers, and rental agents.
|
|
