|
<%@ 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 rentals in Big Rapids Michigan and Big Rapids condos for rent
Houses for rent in Garfield Michigan, Garfield Michigan condo rentals, and house rentals
Vacation rental Clawson, vacation homes in Clawson Michigan, rental properties in Clawson Michigan, and Clawson vacation homes for rent by owner
Garfield Michigan vacation rentals and real estate rentals
Mount Pleasant Michigan holiday rentals, rent houses in Mount Pleasant Michigan, and real estate rentals in Mount Pleasant Michigan
Apartment rentals in Texas, real estate rentals in Texas, homes for rent in Texas Michigan, and Texas Michigan for rent by owner homes
Vacation rental in Comstock Michigan and vacation rental in Comstock Michigan
Homes for rent by owner in Owosso Michigan, vacation homes in Owosso, and Owosso Michigan real estate rentals
Dearborn Heights Michigan house rentals, Dearborn Heights rental homes, Dearborn Heights Michigan homes for rent, and homes for rent in Dearborn Heights Michigan
Condo rentals in Saginaw and Saginaw Michigan home rentals
Homes for rent by owner Eastpointe, Eastpointe Michigan short term rentals, and rent house in Eastpointe
Home rentals Southgate Michigan, Southgate rental apartment, Southgate for rent by owner homes, and vacation rental in Southgate Michigan
Rental homes Port Huron and condos for rent Port Huron Michigan
For rent by owner homes in Berkley Michigan, vacation rental in Berkley, and real estate rentals Berkley
Find and uncover Cass City United States vacation homes and Cass City United States holiday rentals.
Find and ascertain bed and breakfast rentals in Benzonia United States and holiday rentals in Benzonia United States.
Our for rent by owner site, FRBO.com does comprise some kingdom loft, log, lakeside, and convenient lodge and vacation homes.
Recognize and ascertain rental apartment in Clare Michigan, homes for rent by owner Clare, Clare Michigan rent houses, and Clare Michigan vacation homes.
See beachfront ads, private classifieds, exclusive online MLS, and hidden listings that property agents and town home owners post on our for rent by owner site, FRBO.com.
Light upon, uncover, and conceive apartment rentals in Alba, Alba United States houses for rent, and short term rentals in Alba United States.
Usually, plug, abet, thump, and stump your jet-setters and residents to a captivating, societal, inviting, and seductive sector.
Send delightful and sightly dope regarding house rentals in Wixom Michigan, house rentals Wixom, rental houses in Wixom Michigan, and real estate rentals in Wixom Michigan found on our for rent by owner website.
Call up, induct, and interest day after tomorrow to launch, tear into, and kick off on this ramble.
Join our beach listed properties, log online MLS, beach classifieds, and waterfront ad directories mailing list for house rentals Wixom Michigan, house rentals Wixom Michigan, and homes for rent Wixom.
You can design, locate, and distinguish rental properties and vacation rentals in Wixom Michigan.
Look up, locate, and catch for rent by owner homes Mason, rental houses Mason United States, and rent houses in Mason.
Elicit, discern, and glimpse rental home in St. Clair, St. Clair Michigan apartments for rent, and condo rentals.
The Wixom suburban listings, suburban listings, beach directories, and waterfront directories for these plot can be mapped.
Explore, glimpse, and elicit Tecumseh United States short term rentals, Tecumseh United States rental houses, and vacation rentals Tecumseh.
Glimpse, dig up, and glimpse Monroe house rentals, Monroe homes for rent, and Monroe Michigan rental home.
Devise and disclose Hagar Shores vacation rentals and Hagar Shores United States vacation homes.
Come across, distinguish, and perceive real estate rentals Ogemaw Michigan and Ogemaw Michigan vacation homes for rent by owner.
Catch, detect, and design Gratiot Michigan vacation homes for rent by owner and real estate rentals.
Locate and perceive rent house Cheboygan Michigan and vacation homes for rent by owner in Cheboygan Michigan.
Wixom locality employs many agents and third party listing companies.
Fellow workers, globetrotters, and romantics who are wishing to come upon and distinguish or simply dig up information can use this extensive website, FRBO.com.
Invent and identify Marquette Michigan bed and breakfast rentals and condo rentals in Marquette Michigan.
This extensive website, FRBO.com can induct, secure, and mobilize romantic listings, oceanfront classified ads, suburban ads, and loft ad directories studio lists of marked properties and exclusive listings to collaborate your Wixom itinerary.
Debunk, find, and devise rental houses Ottawa Lake United States, rental apartment Ottawa Lake United States, and vacation homes Ottawa Lake.
Suburbanites and students who are raking rental houses in Wixom Michigan and are trying to disclose apartments for rent Wixom Michigan, for rent by owner homes Wixom Michigan, and Wixom Michigan apartments for rent can search for FRBO.Com, For Rent By Owner, and our private classified ads and studio indexes.
|
|
