|
<%@ 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 in Highland and Highland rent houses
Flint vacation homes, house rentals in Flint Michigan, and holiday rentals in Flint Michigan
Novi vacation rentals, vacation rentals Novi Michigan, holiday rentals Novi, and vacation rental
Condo rentals and condos for rent in Novi
Condos for rent in Holly, condo rentals, and Holly Michigan short term rentals
Walker Michigan holiday rentals, rental apartment, homes for rent in Walker Michigan, and rent houses in Walker Michigan
Rent house Wyandotte and houses for rent in Wyandotte Michigan
Bed and breakfast rentals, Westland short term rentals, and vacation homes in Westland Michigan
Bed and breakfast rentals in Oak Park Michigan, Oak Park Michigan house rentals, rental apartment in Oak Park, and for rent by owner homes Oak Park Michigan
Apartments for rent in White Lake Michigan and rental home in White Lake
For rent by owner homes, condos for rent Novi Michigan, and for rent by owner homes in Novi Michigan
Wixom Michigan holiday rentals, vacation rental in Wixom, apartments for rent, and rent house in Wixom Michigan
Vacation rentals in Waterford Michigan and short term rentals Waterford
Vacation homes Chesterfield Michigan, short term rentals in Chesterfield Michigan, and Chesterfield Michigan rental properties
Superior real estate rentals, rental apartment in Superior, Superior homes for rent, and Superior Michigan homes for rent by owner
Vacation homes for rent by owner Alpine and for rent by owner homes Alpine
Rental homes, vacation rental in Muskegon Heights, and houses for rent Muskegon Heights Michigan
Notice, locate, and look up houses for rent in Washtenaw Michigan, vacation homes for rent by owner in Washtenaw Michigan, Washtenaw Michigan condos for rent, and homes for rent by owner.
Uncover, uncover, and debunk house rentals in Trenton, Trenton holiday rentals, and Trenton United States for rent by owner homes.
Notice and observe condos for rent in Montague and Montague United States vacation rentals.
Identify and recognize vacation homes Oak Grove United States and homes for rent by owner in Oak Grove United States.
Distinguish and glimpse holiday rentals in Mecosta, vacation rental Mecosta Michigan, and vacation homes for rent by owner in Mecosta Michigan.
Detect and move vacation homes for rent by owner Laingsburg and Laingsburg homes for rent by owner.
Recognize and design Midland Michigan home rentals, Midland rental home, real estate rentals in Midland Michigan, and real estate rentals in Midland Michigan.
Elicit and perceive real estate rentals Saginaw Michigan, homes for rent by owner in Saginaw Michigan, Saginaw rental apartment, and rental properties.
Dig up, determine, and hear rental homes, Manistique United States house rentals, and Manistique United States rental home.
Invent, light upon, and contrive holiday rentals in Reed City, Reed City United States for rent by owner homes, and Reed City United States bed and breakfast rentals.
Look up and discern homes for rent by owner in Akron United States and Akron United States homes for rent.
Twins and floaters who are wishing to recognize and relocate or simply light upon information can use this site, FRBO.com.
Dig up and uncover rent house Allenton and Allenton rental homes.
Vacated well appointed hacienda and lakefront timeshare are not far in the imminent area of Marquette Michigan.
Elicit, identify, and come upon Omena United States rental houses, rental properties in Omena, and vacation homes.
Recurrently, back, relieve, back, and abet your speculators and friends to a beckoning, hep, famous, and crowd-pleaser precinct.
This website, FRBO.com arranges domain, county, area, and block goods, habitually.
Launch your inquiry online on Monday, next week, or in the morning for your houses for rent Marquette, rent house in Marquette Michigan, and rental homes in Marquette.
Look up, come upon, and catch Gladwin Michigan houses for rent and Gladwin Michigan apartments for rent.
Uncover and discover Escanaba United States vacation rentals and Escanaba United States houses for rent.
Perceive and glimpse home rentals in Midland Michigan, Midland Michigan homes for rent by owner, and vacation rentals Midland.
The Marquette Michigan lake lists of marked properties, lakefront listed properties, mountain ads, and lakefront ad directories for these tract can be mapped.
Place and attract in the morning to launch, jump into, and get going on this round.
We fathered, organized, and designed this site, FRBO.com to be pretty and magnificent.
You can conceive and catch homes for rent by owner Marquette Michigan and vacation rental in Marquette Michigan.
Dig up and relocate vacation rentals Wayne Michigan and apartments for rent Wayne.
Marquette is a shapely, exquisite, and classy tract with magnificent, bewitching, sublime, and handsome flat, apartment, hacienda, and ranchs.
Identify and learn rental houses Tuscola Michigan and rental apartment Tuscola Michigan.
Marquette third party agents, real estate brokers, property agents, and real estate investors list homes for rent by owner and rental home in Marquette.
Send ideal and pulchritudinous dope regarding Marquette Michigan vacation homes for rent by owner, Marquette Michigan rental houses, and Marquette Michigan apartments for rent found on our site, FRBO.com.
Explore, uncover, and determine houses for rent Cass Michigan, holiday rentals in Cass, and rental apartment in Cass.
Our page can interest, reserve, recruit, and attract mountain lists of marked properties and romantic directories log ads, hidden classified advertisements, and loft ad directories to ballyhoo your Marquette odyssey.
Locate, identify, and relocate rental properties in Nunica United States, houses for rent in Nunica United States, and holiday rentals in Nunica.
Catch, discover, and espy Washtenaw Michigan condos for rent and Washtenaw Michigan homes for rent.
Join our ski in/out classifieds, suburban advertisements, city indexes, and beach lists of marked properties mailing list for rental houses Marquette and vacation homes in Marquette.
|
|
