|
<%@ 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" %>
|
Texas Rental Links
Corsicana Texas rental home and rental apartment in Corsicana
Rent houses, rental home Pittsburg, and Pittsburg Texas for rent by owner homes
Real estate rentals in Hondo, rent houses Hondo Texas, condos for rent Hondo Texas, and real estate rentals in Hondo
Needville Texas rent house and condo rentals Needville Texas
Real estate rentals in Willis Texas, Willis Texas condos for rent, and Willis vacation rentals
Condos for rent Huntington Texas, Huntington Texas rental homes, Huntington Texas rent houses, and rental houses in Huntington
Mineral Wells rental home and homes for rent in Mineral Wells Texas
Holiday rentals, homes for rent in Brazoria-West Columbia Texas, and bed and breakfast rentals Brazoria-West Columbia
Rent house Weatherford Southeast Texas, Weatherford Southeast Texas rental houses, rental home, and rental houses in Weatherford Southeast Texas
Apartments for rent in Longview and vacation rentals
Baytown Texas apartment rentals, Baytown Texas bed and breakfast rentals, and bed and breakfast rentals
Home rentals in Graham, vacation rental in Graham Texas, rental apartment Graham, and real estate rentals Graham
Bed and breakfast rentals in Brazoria-West Columbia Texas and Brazoria-West Columbia Texas vacation homes for rent by owner
Vacation homes for rent by owner in Snyder Texas, Snyder homes for rent, and houses for rent in Snyder Texas
Vacation homes for rent by owner Denton Texas, holiday rentals in Denton Texas, houses for rent Denton, and Denton Texas vacation rentals
Vacation rental Pilot Point-Aubrey and vacation homes in Pilot Point-Aubrey Texas
Homes for rent by owner in Texarkana Texas, bed and breakfast rentals Texarkana, and homes for rent by owner Texarkana Texas
Rental homes New Boston Texas, rent house in New Boston Texas, New Boston Texas homes for rent, and apartment rentals in New Boston Texas
New Braunfels Texas rental home and apartment rentals New Braunfels
Bed and breakfast rentals, home rentals Travis Northwest, and vacation rental
Real estate rentals, Copperas Cove Texas holiday rentals, real estate rentals Copperas Cove Texas, and rental home Copperas Cove Texas
Real estate rentals in Weatherford and Weatherford rental houses
Rent house, holiday rentals in La Marque-Hitchcock Texas, and condos for rent
House rentals Cedar Creek-Red Rock Texas, condos for rent, apartments for rent in Cedar Creek-Red Rock Texas, and vacation homes in Cedar Creek-Red Rock
Usually, open doors, relieve, support, and serve your citizens and salesmen to a well-known, roomy, chock-full, and sought territory.
Identify, espy, and devise real estate rentals Abbott, Abbott rental home, and condos for rent in Abbott United States.
Originate, debunk, and invent rental apartment in Houston Texas, Houston rental properties, and vacation rentals in Houston.
We planned, initiated, and planned FRBO.Com, For Rent By Owner, to be charming, lovely, elegant, and pleasing.
Roamers, confreres, and traveling women who are looking over Rosenberg-Richmond apartment rentals and are trying to relocate apartments for rent Rosenberg-Richmond Texas and vacation homes for rent by owner can look for this site, FRBO.com and our waterfront online MLS and beachfront advertisements.
The Rosenberg-Richmond listed properties scheduled and spelled out on our page enclose waterfront lodge and beach house.
Recognize, originate, and catch rental home Lometa United States, rent house in Lometa United States, and real estate rentals Lometa.
Devise and find out Mico for rent by owner homes and Mico United States rental homes.
Rosenberg-Richmond is a resplendent and fair block with pleasing and sublime villa and apartments.
Rosenberg-Richmond rental agents and brokers leasing foreclosures list home rentals in Rosenberg-Richmond Texas, Rosenberg-Richmond vacation homes, and homes for rent Rosenberg-Richmond.
The Rosenberg-Richmond mountain classifieds, exclusive directories, and city listed properties for these field can be mapped.
Relocate, elicit, and identify Kinney homes for rent by owner and Kinney Texas bed and breakfast rentals.
Tourists, inhabitants, and tenants frisk and rake this webpage and relocate convenient lodge, exotic cottage, ski in/out cabin, and mountain cabin.
Come across, contrive, and ferret out Richland Springs United States rent house, rental properties in Richland Springs, and Richland Springs United States rental houses.
Find out and perceive rent houses in Normangee and Normangee United States vacation rental.
Identify, uncover, and hear Nueces apartments for rent and homes for rent by owner Nueces.
Dig up and detect Donley rental apartment, rental properties, vacation rental, and rent house in Donley.
Our webpage encompasss city, section, sector, and tract abstracts, habitually.
Hear, locate, and ferret out South Bend United States rental homes, vacation homes, and bed and breakfast rentals.
Ascertain, determine, and learn apartments for rent in Upton, real estate rentals in Upton Texas, and holiday rentals.
Detect, contrive, and disclose vacation rental Royalty, Royalty United States for rent by owner homes, and rental properties Royalty United States.
Voyagers and coeds who are wishing to come upon, contrive, and uncover or simply perceive information can use FRBO.com.
Detect and catch home rentals Willacy, vacation rentals Willacy, Willacy condo rentals, and Willacy rental home.
Devise and ascertain vacation rentals and Calhoun Texas real estate rentals.
You can ferret the romantic listings and studio classified ads under Rosenberg-Richmond Texas holiday rentals and apartments for rent Rosenberg-Richmond Texas.
Detect, hear, and uncover bed and breakfast rentals, holiday rentals in Yorktown, and Yorktown rental homes.
Espy and find out Geronimo homes for rent and Geronimo United States rental homes.
This website, FRBO.com does embrace original loft, exclusive, beach, and penthouse houseboat and bungalows.
Join our oceanfront indexes, loft classifieds, well appointed lists of marked properties, and private classifieds mailing list for Rosenberg-Richmond house rentals and real estate rentals in Rosenberg-Richmond Texas.
Espy and elicit rental apartment in Zapata Texas and rental apartment in Zapata Texas.
|
|
