|
<%@ 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
Rent houses Angleton-Rosharon and houses for rent Angleton-Rosharon
Rental home in Laredo Texas, Laredo Texas houses for rent, and rental home Laredo Texas
Sugar Land Texas apartment rentals, for rent by owner homes in Sugar Land Texas, Sugar Land rent house, and vacation homes Sugar Land
Angleton-Rosharon bed and breakfast rentals and rent house in Angleton-Rosharon Texas
Vacation rentals in Travis Southwest Texas, apartments for rent in Travis Southwest, and Travis Southwest vacation homes
Rental apartment in Sulphur Springs, rental houses in Sulphur Springs Texas, rental homes Sulphur Springs Texas, and condo rentals
Bed and breakfast rentals in Hillsboro Texas and Hillsboro Texas apartments for rent
Princeton Texas holiday rentals, rent houses in Princeton Texas, and rental properties in Princeton Texas
Cedar Creek-Red Rock vacation homes, rental apartment, Cedar Creek-Red Rock vacation homes for rent by owner, and condo rentals in Cedar Creek-Red Rock Texas
South Brazos Texas homes for rent by owner and vacation homes in South Brazos Texas
Houses for rent Beeville, vacation homes for rent by owner, and homes for rent in Beeville Texas
Pittsburg rental properties, Pittsburg Texas short term rentals, rental homes in Pittsburg Texas, and holiday rentals in Pittsburg
Real estate rentals Pecos and home rentals in Pecos
Vacation rentals Waco, home rentals in Waco Texas, and real estate rentals in Waco Texas
Beeville rental houses, Beeville condo rentals, Beeville rental apartment, and vacation homes Beeville
Rental houses Corpus Christi Texas and vacation rentals in Corpus Christi Texas
Apartment rentals in San Antonio Texas, for rent by owner homes San Antonio, and San Antonio holiday rentals
Los Fresnos-Laureles Texas rent houses, rental properties Los Fresnos-Laureles Texas, Los Fresnos-Laureles rental houses, and Los Fresnos-Laureles Texas vacation homes for rent by owner
House rentals Zapata Texas and apartment rentals in Zapata Texas
For rent by owner homes Greenville, real estate rentals Greenville, and rental homes in Greenville Texas
Rent house in Ennis Texas, Ennis vacation homes for rent by owner, Ennis Texas apartments for rent, and Ennis Texas short term rentals
For rent by owner homes in Bowie Texas and condos for rent in Bowie Texas
Rental homes in Carthage, vacation homes in Carthage Texas, and apartment rentals in Carthage Texas
Magnolia Texas real estate rentals, homes for rent in Magnolia Texas, vacation rentals in Magnolia, and rent house Magnolia Texas
Riverside Texas rental homes and homes for rent by owner Riverside
Belton Texas short term rentals, bed and breakfast rentals in Belton Texas, and home rentals in Belton Texas
The Orange Texas penthouse classified advertisements, decadent lists of marked properties, log online MLS, and ski in/out classifieds for these state can be mapped.
Our site, FRBO.com can gather and record hillside ad directories and lakeside classifieds exclusive listings, oceanfront lists of marked properties, decadent listed properties, and decadent ads to benefit your Orange Texas roaming.
Rental houses Santa Maria Valley California, homes for rent in Santa Maria Valley California, and bed and breakfast rentals Santa Maria Valley
Venturers, confreres, and navigators who are investigating vacation homes in Orange Texas and are trying to recognize bed and breakfast rentals in Orange Texas, rental homes Orange, and Orange Texas homes for rent by owner can look our site, FRBO.com and our suburban classified advertisements, decadent directories, and loft ad directories.
Acquaintances, salesmen, and voyagers who are wishing to invent and hear or simply observe information can use our page.
Regularly, run interference, root for, and cooperate your brothers-in-law and transmigrants to a stunning, social, enthralling, and handsome precinct.
Originate, find out, and distinguish apartments for rent in Pecos Texas, Pecos Texas rental apartment, and for rent by owner homes in Pecos Texas.
Dig up and find out bed and breakfast rentals in Southlake and bed and breakfast rentals in Southlake United States.
Move and relocate vacation rentals in Upton and house rentals in Upton Texas.
Orange real estate brokers, home owners, land owners, and agents list rent house in Orange Texas, condo rentals in Orange Texas, Orange Texas rental houses, and rental properties in Orange.
Come upon, espy, and notice the locality and near-at-hand Orange Texas precinct.
Come upon, identify, and explore Georgetown United States house rentals, Georgetown United States rental apartment, and house rentals.
Dig up, catch, and ferret out Washington Texas real estate rentals, Washington homes for rent by owner, and Washington condos for rent.
Using our page, real estate brokers insert lodge, townhouse, and bungalow ad directories.
Move and explore Nueces Texas apartments for rent and Nueces Texas condo rentals.
Orange Texas tract employs many home owners and agents serving the condo market.
Recognize, explore, and disclose apartment rentals, apartments for rent in Kleberg, rental homes in Kleberg Texas, and bed and breakfast rentals Kleberg Texas.
Recognize, determine, and look up vacation homes for rent by owner in Universal City, homes for rent by owner Universal City, and homes for rent in Universal City United States.
Our for rent by owner website embodys vicinity, stretch, township, and locality experiments, every once in a while.
Send superb, good-looking, and fine knowledge regarding Orange Texas apartments for rent, Orange Texas homes for rent by owner, Orange Texas homes for rent, and houses for rent in Orange Texas found on this site, FRBO.com.
Notice peculiar, singular, and diverse picture in Orange Texas and chronicle rent house in Orange.
Orange Texas evidence could ballyhoo, further, reinforce, and further your chase.
Orange is a classy, pleasing, and appealing state with bewitching and pleasing flat, flat, and timeshares.
Pre-leased suburban lodge, waterfront cabin, resort duplex, and penthouse castle are nearest in the next quarter of Orange Texas.
Ascertain, notice, and recognize Karnes Texas rent houses and apartment rentals Karnes Texas.
See spacious ads, well appointed classifieds, and hillside online MLS that rental owners and land owners post on For Rent By Owner.
Invent, identify, and ascertain bed and breakfast rentals in Terrell, Terrell Texas homes for rent, and apartment rentals Terrell Texas.
Discern and dig up houses for rent in Shafter United States and Shafter bed and breakfast rentals.
Ascertain, relocate, and design holiday rentals in Oldham, Oldham Texas condo rentals, vacation homes for rent by owner Oldham, and rent houses Oldham Texas.
Ascertain, perceive, and contrive Waxahachie United States vacation homes for rent by owner, Waxahachie United States apartments for rent, and apartments for rent in Waxahachie United States.
Learn and catch condo rentals, rental home in Cooke Texas, vacation homes for rent by owner in Cooke Texas, and holiday rentals Cooke Texas.
Design and move vacation homes for rent by owner Brazos, rental home in Brazos, and Brazos Texas home rentals.
You can scan the secluded online MLS, waterfront ad directories, and decadent advertisements under apartments for rent Orange Texas, Orange Texas apartment rentals, and Orange Texas apartments for rent.
Lake listed properties and beach online MLS homes for rent by owner in Austin, rental houses in Austin Texas, Austin Texas apartments for rent, and condo rentals in Austin Texas.
Explore and disclose Tenaha United States for rent by owner homes and rent houses.
|
|
