Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T06:51:23.153' ,`MLSNumber` = '47383965' ,`ListAgentFullName` = 'Traci Crawford' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = 'Charlene Findley' ,`SellingOfficeName` = 'Boom Real Estate' ,`Latitude` = '29.815237' ,`Longitude` = '-94.810686' ,`PhotoCount` = '30' ,`PostalCode` = '77523' ,`RoomCount` = '3' ,`ListPrice` = '345000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Gou Hole' ,`StreetNumber` = '901' ,`StreetSuffix` = 'Road' ,`City` = 'Cove' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this RARE find in the highly acclaimed Barbers Hill Independent School District. This home sits on an unrestricted acre near the Hugo boat ramp, surrounded by beautiful mature trees, and is ready for its new owners. Inside, you will find an open concept living room with wood burning fireplace and kitchen with breakfast nook overlooking the beautiful backyard. The split floor plan offers privacy to the oversized secondary bedrooms and primary bedroom. In the backyard, you have a beautiful covered patio perfect for entertaining, full fenced backyard for privacy, a 10\'x16\' shed for tools and toys, and a well house. Pride of ownership is displayed throughout and with fresh paint, brand new septic system (04/2022), and immaculately clean, this property is TURN-KEY! Call to schedule your showing today!' ,`Acres` = '1' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '306 TR 62-510 ABJ WINFREE' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'ABJ WINFREE' ,`TaxAmount` = '3001' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667412099' WHERE `Matrix_Unique_ID` = '207020731' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T06:10:39.613' ,`MLSNumber` = '45250568' ,`ListAgentFullName` = 'Scott Zabiegala' ,`ListOfficeName` = 'Carswell Real Estate Co. Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.251977' ,`Longitude` = '-95.570315' ,`PhotoCount` = '46' ,`PostalCode` = '77354' ,`RoomCount` = '10' ,`ListPrice` = '869900.00' ,`Status` = 'Active' ,`StreetName` = 'BLUE LAKE DRIVE' ,`StreetNumber` = '2510' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated home on 1.35 waterfront acres. Enjoy your own dock and water access from your very own backyard. This 4 bedroom 3 bath and 3 car detached garage open concept home has everything you are looking for. High ceilings throughout. Chef\'s kitchen with quartz counter tops and Stainless Steel Appliances. Built in breakfast area. Master suite overlooking the lake! Walk in shower with his and her shower heads. Private study, and game room for the kids. 2 bedrooms share a Hollywood bath. Tankless water heater and gas appliances. Zoned to the highly desired Montgomery ISD (Lake Creek High School), and only minutes from Woodforest Golf Club and Amenities.' ,`Acres` = '1.35' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Montgomery Trace 02, BLOCK 1, Lot 18' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '58762' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'MONTGOMERY TRACE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412099' WHERE `Matrix_Unique_ID` = '209821422' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:49:53.773' ,`MLSNumber` = '29374494' ,`ListAgentFullName` = 'Jessica Gunn' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791296' ,`Longitude` = '-95.524392' ,`PhotoCount` = '22' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '408000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedarpost Square Street' ,`StreetNumber` = '9515' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2339' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite wood flooring, granite countertops in kitchen, stainless steel appliances, separate wet bar with wine refrigerator, and separate media section! This home has the option to transfer furnishings as well as a refrigerator, washer, and dryer. The primary bathroom features a walk-in shower with a separate garden tub and is connected to an extra-large bedroom. Privacy, elegance, and low maintenance are what you can expect with this home! Only minutes away from Energy Corridor & City Centre in a gated community. This home also has a grant program available for buyers that qualify.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Blk 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '2016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2304' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cedarpost Square' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412099' WHERE `Matrix_Unique_ID` = '210322126' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:52:01.427' ,`MLSNumber` = '3722613' ,`ListAgentFullName` = 'Jo Krejci' ,`ListOfficeName` = 'Champion Real Estate ' ,`SellingAgentFullName` = 'Alfredo Sabal' ,`SellingOfficeName` = 'Krueger Real Estate' ,`Latitude` = '29.887038' ,`Longitude` = '-95.931449' ,`PhotoCount` = '35' ,`PostalCode` = '77423' ,`RoomCount` = '4' ,`ListPrice` = '375000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Quail' ,`StreetNumber` = '32402' ,`StreetSuffix` = 'Run' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2148' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living right outside of the city. This beautifully renovated home sits on 1.21 acres with a pond, mature trees, and a detached garage. This home is 4 bedrooms, 2.5 baths, and has an awesome media/game room. It is recently renovated with new flooring throughout the first and second floor with new paint throughout. The kitchen is one-of-a-kind and completely renovated with new stainless steel appliances. This home is situated on a cul-de-sac with great neighbors. It has fencing on the perimeter of the property, including wrought iron fencing and upgraded window treatments for a modern country feel. \r\n New pump for water system, \r\n New ac system, \r\n New flooring upstairs & downstairs, \r\n Quartz countertops, \r\n Paint throughout, \r\n New landscaping, \r\n Solar panels.\r\nBring your horses and chickens to start your country living. Room sizes to be independently verified by buyer. Possession will be within 24 after closing and funding.' ,`Acres` = '1.21' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S669100 PEREGRINE ESTATES 2 LOT TR 105 ACRES 1.21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '52708' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Peregrine Estates 2' ,`TaxAmount` = '3755' ,`TaxRate` = '2.0967' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412100' WHERE `Matrix_Unique_ID` = '210944232' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:33:36.490' ,`MLSNumber` = '32417042' ,`ListAgentFullName` = 'Frank Liu' ,`ListOfficeName` = 'Lovett Realty, Inc' ,`SellingAgentFullName` = 'Ashley Heacock' ,`SellingOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`Latitude` = '29.754488' ,`Longitude` = '-95.498807' ,`PhotoCount` = '14' ,`PostalCode` = '77057' ,`RoomCount` = '7' ,`ListPrice` = '1150000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wood Hollow' ,`StreetNumber` = '1254' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3819' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION, 4 BEDROOMS, 4.5 baths, 3 CAR GARAGE. THIS HOME IS UNDER CONTRACT, BUT WE HAVE OTHER NEW HOMES UNDER CONSTRUCTION TO VIEW. WALK TO WHOLE FOODS, Gated lock and leave lifestyle in a fabulous Tanglewood/Memorial location within walking distance to Whole Foods, shopping, dining, and Second Baptist Church. Gated luxury lifestyle with a community pool. INSTALLED ELEVATOR. Roof top terrace with an outdoor fireplace in addition to a small fenced in yard space for your furry friends. Chef\'s kitchen features custom inset cabinetry, 48\" range with double ovens, 6 burners & a griddle. Wonderful open floor plan for entertaining with 12 ft ceilings in the living areas. Luxury finishes and plenty of Eco-Hip \"green\" features for low maintenance living. Wide plank wood flooring throughout, no carpet. Pictures are of similar homes by builder.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Spyglass Homes, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 TANGLEWOOD HOLLOW' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2395' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Hollow' ,`TaxAmount` = '2380' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667412100' WHERE `Matrix_Unique_ID` = '211312021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:35:17.170' ,`MLSNumber` = '83910460' ,`ListAgentFullName` = 'Frank Liu' ,`ListOfficeName` = 'Lovett Realty, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754537' ,`Longitude` = '-95.498681' ,`PhotoCount` = '13' ,`PostalCode` = '77057' ,`RoomCount` = '4' ,`ListPrice` = '849900.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Hollow' ,`StreetNumber` = '1248' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WALK TO WHOLE FOODS, fabulous Tanglewood/Memorial location within walking distance to Whole Foods, numerous restaurants, shopping, & Second Baptist Church. This wonderful new construction single family home is located in a gated luxury lifestyle community of 39 homes with a COMMUNITY POOL. Chef\'s kitchen features high end 48\" range with double ovens, 6 burners, & a griddle, & custom double stacked cabinetry with soft close drawers and doors. Wonderful open floor plan for entertaining with 12ft ceilings in the living area. Luxury finishes and plenty of Eco-Hip \"green\" features for low maintenance living. 4th floor game room could be used as a 4th bedroom, INSTALLED ELEVATOR included, & wood flooring throughout, no carpet.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Spyglass Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 1 TANGLEWOOD HOLLOW' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2395' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Hollow' ,`TaxAmount` = '2380' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667412100' WHERE `Matrix_Unique_ID` = '211321092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:28:25.163' ,`MLSNumber` = '89629251' ,`ListAgentFullName` = 'Deanna Essmyer' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Greg Tidmore' ,`SellingOfficeName` = 'TMND Realty' ,`Latitude` = '29.772513' ,`Longitude` = '-95.564167' ,`PhotoCount` = '20' ,`PostalCode` = '77079' ,`RoomCount` = '9' ,`ListPrice` = '500000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Memorial' ,`StreetNumber` = '12915' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Multiple offers! Highest and best due today at 5 o’clock. Dream Location Packed with Potential! Memorial is a hotspot offering a rich & balanced lifestyle; ideal for a family on the move. This cool Mid Century Modern is LOT VAlUE, AS IS. The land here is so sought-after offering large yards, leafy lined streets in front of picturesque homes & zoned to award winning SBISD schools, including Nationally Ranked Rummel Creek Elementary. Easy Access, excellent schools, parks, recreation, & all the amenities for modern living, including proximity to two of Houston’s core employment Centers, Energy Corridor & Galleria/Uptown makes Memorial a lush neighborhood & community with all the perks of urban living. There’s no need to trek far for any necessity including shopping & excellent dining either. 12915 Memorial Drive is the perfect opportunity to work where you play. Envision your new home on this sizable lot, schedule a showing or drive by. Make an offer today!' ,`Acres` = '0.2824' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 MEMORIAL BEND SEC 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '12300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '411' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Bend Sec 01' ,`TaxAmount` = '10766' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412100' WHERE `Matrix_Unique_ID` = '211514241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:20:15.627' ,`MLSNumber` = '59478439' ,`ListAgentFullName` = 'N. Roxanne Silva' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.553779' ,`Longitude` = '-95.126048' ,`PhotoCount` = '26' ,`PostalCode` = '77062' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Rigger Ln' ,`StreetNumber` = '16603' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All brick construction, large corner cul-de-sac lot, split floorplan, established safe neighborhood, mature trees, spacious private backyard, not in flood zone, has never flooded, newly remodeled bathrooms and kitchen, freshly painted interior, alarm system, new garage door and concrete driveway, garage equipped with A/C ducting and cabinets for plenty of storage. Foundation repaired with lifetime, transferable warranty. Home has an extra-large covered patio with LED lighting, ceiling fans, and built-in speakers and plenty of room to accommodate your patio furniture for your family gatherings! Close proximity to Clear Lake Medical Center, NASA, Galveston, Kemah, University of Houston Clear Lake, Exploration Green, BayBrook Mall, and many restaurants and entertainment venues. Low tax rate and HOA! Zoned to Clear Creek ISD!' ,`Acres` = '0.2194' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 46 CAMINO SOUTH SEC 4' ,`LotDesciption` = 'Cleared,Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9559' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '61' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WHITCOMB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Camino South' ,`TaxAmount` = '5743' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412100' WHERE `Matrix_Unique_ID` = '212061014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:18:48.127' ,`MLSNumber` = '50188582' ,`ListAgentFullName` = 'Bobby Allen' ,`ListOfficeName` = 'JMP Realty Partners LLC' ,`SellingAgentFullName` = 'Angela Lucas' ,`SellingOfficeName` = 'J. Woodley Realty, LLC' ,`Latitude` = '29.609231' ,`Longitude` = '-95.493655' ,`PhotoCount` = '14' ,`PostalCode` = '77489' ,`RoomCount` = '7' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Timberlea Drive' ,`StreetNumber` = '15011' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story home in Willow Park community. Open space floor plan connecting family room, kitchen and breakfast area. Gas fireplace in family room.Fresh paint inside and out. Roof, water heater and plumbing have been recently replaced. No Carpet. Beautiful LVP, luxury vinyl planks and title. Kitchen new sink, fixtures and dishwasher. Covered rear 10x14 patio. Large fenced in back yard with storage shed. Well established neighborhood in the \"Chasewood\" area of Missouri City. Easy access to Ft. Bend Tollway and Sam Houston Pkwy.' ,`Acres` = '0.1858' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WILLOW PARK (RES A) SEC 2, BLOCK 2, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8094' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '145' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BRIARGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLOWRIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'MCAULIFFE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Willow Park Residence A Sec 2' ,`TaxAmount` = '3553' ,`TaxRate` = '2.2137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412101' WHERE `Matrix_Unique_ID` = '212186361' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:11:41.830' ,`MLSNumber` = '11750041' ,`ListAgentFullName` = 'Tracy Argo' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.967610' ,`Longitude` = '-95.506035' ,`PhotoCount` = '18' ,`PostalCode` = '75862' ,`RoomCount` = '7' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood Forest Trail' ,`StreetNumber` = '328' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome private lake getaway in Trinity Texas. This traditional home sits on almost an acre, with 3 acres across the street that comes with the property! This, 4-bedroom, 3 full bath home has a commercial gas range and a stainless-steel refrigerator. The back deck looks onto lake Jenifer with beautiful views and a very large partially fenced back yard with a fishing pier. Whether a weekend getaway, your first home, investment property or a place to call home, this is it!' ,`Acres` = '4' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Walker County - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE JENNIFER SECTION A-1, LOT 3 PT OF, 4' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Jennifer Sec A-1' ,`TaxAmount` = '3677' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412101' WHERE `Matrix_Unique_ID` = '212632483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:52:07.977' ,`MLSNumber` = '55090281' ,`ListAgentFullName` = 'Collette King' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.015972' ,`Longitude` = '-95.685329' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '14' ,`ListPrice` = '1295000.00' ,`Status` = 'Active' ,`StreetName` = 'Kitzman' ,`StreetNumber` = '18307' ,`StreetSuffix` = 'Road' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HEART OF CYPRESS! HORSE-LOVER\'S DREAM! -/+5 Acres Private gated pool home on park-like acreage w/ a covered lighted riding arena, 5 stall barn & attached living quarters. This 5-bedroom home presents an alluring front porch to enjoy beautiful sunsets, circular drive, double-gated property. 2 bedrooms down/master down w/ study. White cabinets in kitchen w/ s/s app. sep. ice maker, trash compactor, island gas Viking cooktop, corner sink, brkfst bar, built-in fridge, convection microwave & more. Custom-built mantel w/ gas fireplace in large family rm! Double-paned windows thruout. Over-sized laundry rm. Grandiose formal dining rm is open to the kitchen & perfect for entertaining. Private master suite w/ sitting area. Master bath w/ his/her closets, his & her vanities & separate tub/shower. 3 large bedrms upstairs, two full baths, a great-sized game rm w/ a wet bar. Wrought iron staircase w/ exquisite wood stairs. Pool & spa w/ rock waterfall. Cvd back patio! & a tree house! NEVER FLOODED!' ,`Acres` = '4.586' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 11 R/S TRS 15 & 19 THRU 23 ABST 226 J DUCKWORTH' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '199766' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Wood Estates' ,`TaxAmount` = '15456' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412101' WHERE `Matrix_Unique_ID` = '212883827' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:17:25.027' ,`MLSNumber` = '8248793' ,`ListAgentFullName` = 'Gloria Alvarado' ,`ListOfficeName` = 'SES Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699115' ,`Longitude` = '-95.155582' ,`PhotoCount` = '22' ,`PostalCode` = '77503' ,`RoomCount` = '6' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Edgefield' ,`StreetNumber` = '3811' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bring your design ideas to this 3/2/2 home in Parkwood Estates. Conveniently located minutes away from Beltway 8 and Highway 225 for easy access to anywhere in the greater Houston area! This home has good bones and is ready for a remodel. The family room opens to the breakfast room and kitchen. The roof was replaced in 2008. Central Air and Heat, but the HVAC system needs to be repaired/replaced. Best of all, absolutely NO FLOODING during Hurricane Harvey. This home does need some work, but not extensive it has incredible potential. Call today for a private showing!' ,`Acres` = '0.176' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 2 PARKWOOD ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7665' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MCMASTERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SANJACINTO INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood Estates' ,`TaxAmount` = '3914' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412101' WHERE `Matrix_Unique_ID` = '213205426' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T06:22:45.223' ,`MLSNumber` = '69454645' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819052' ,`Longitude` = '-95.063041' ,`PhotoCount` = '18' ,`PostalCode` = '77562' ,`RoomCount` = '5' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Woods' ,`StreetNumber` = '423' ,`StreetSuffix` = 'Drive' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beutiful 3beds,2baths,2car garage house. Located in the area you want to live!!! It has many recent update in throughout the house. Some updates include granite counter in kitchen, beautiful interior paint, appliances, lights and spot lights, carpet, and a few other more. NEW A/C AND HEATTING SYSTEM!!!!!was installed.' ,`Acres` = '0.1848' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 4 HIGHLAND WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Woods Sec 01' ,`TaxAmount` = '4133' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412102' WHERE `Matrix_Unique_ID` = '213457929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:54:09.203' ,`MLSNumber` = '25328378' ,`ListAgentFullName` = 'Nehal Farrag' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.590134' ,`Longitude` = '-95.662302' ,`PhotoCount` = '31' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Grassy' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Knolls' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4534' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will love this spacious home located on a large lot in a cul-d-sac in the sought after New Territory! This 5 bedroom and 3 1/2 bath has lots of upgrades and a beautiful pool! On the first floor you will find a living room, formal room, dining room and an office along with a large kitchen with lots of storage and a great sized pantry. You will also find the primary bedroom with a view of the pool with a large walk in bathroom. On the second floor, there are 4 spacious bedrooms with walk in closets with 2 jack and jills connecting the bedrooms. The game room has a great built in for all your storage needs. Need more storage? This home also features an huge attic walk space to put all of your extras belongings. The yard is huge with a covered porch, sparkling pool which was recently replastered and lots of yard space! The home also has fully equipped speakers, total security system, sprinkler system which can all be controlled from your phone. Come check this house out today!' ,`Acres` = '0.2997' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NEW TERRITORY PARCEL SF-18, BLOCK 1, LOT 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13055' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'WALKER STATION ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'SARTARTIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'New Territory Prcl Sf-18' ,`TaxAmount` = '12269' ,`TaxRate` = '2.4394' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667412102' WHERE `Matrix_Unique_ID` = '213690104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T06:58:09.623' ,`MLSNumber` = '21827438' ,`ListAgentFullName` = 'Sandra Sawyer' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.645732' ,`Longitude` = '-95.225982' ,`PhotoCount` = '17' ,`PostalCode` = '77034' ,`RoomCount` = '8' ,`ListPrice` = '219999.00' ,`Status` = 'Active' ,`StreetName` = 'Edgebrook' ,`StreetNumber` = '531' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1390' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You’ve got to come see all the updates in this recently remodeled home! Windows, central A/C, furnace, bathrooms, stainless appliances including double-oven, water heater, cabinets, lighting, flooring, all recently replaced. Second bathroom straight down the hall so convenient for your guests, giving you a private bathroom! Vacant and ready to move in! Conveniently located to I-45 & Beltway 8 (Sam Houston tollway), you can zip to downtown, or all around Houston, or down to the beach! And no HOA for added freedoms with ownership!' ,`Acres` = '0.1655' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 56 FREEWAY MANOR SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7209' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FREEMAN ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Freeway Manor' ,`TaxAmount` = '3777' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412102' WHERE `Matrix_Unique_ID` = '213817683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:49:09.173' ,`MLSNumber` = '9279839' ,`ListAgentFullName` = 'Nancy Albea' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739070' ,`Longitude` = '-95.476229' ,`PhotoCount` = '50' ,`PostalCode` = '77056' ,`RoomCount` = '14' ,`ListPrice` = '1389000.00' ,`Status` = 'Active' ,`StreetName` = 'Locke' ,`StreetNumber` = '5654' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your oasis in the city! Custom built by Habitat Construction in October 2015, this home features elegance and exquisite craftsmanship. Chef\'s Kitchen is complete with Wolf and Sub-Zero appliances, butler\'s pantry and Summit wine fridge. Hardwood floors run throughout including the stairs perfected with hand-crafted iron rails. Primary suite boasts a 5-piece bathroom and a dream closet with wall-to-wall cabinetry. Upstairs features a large game room and 2 built-in desks. Exterior matches interior in beauty and quality, including a shimmering pool and spa (with iAqualink system), brand new commercial-grade electric gate motor with myQ wireless entry and manual opener, extended driveway into a port cochere, increased insulation, gutters with leaf guard, pre-wired for exterior sound system, automated pest control system, and over 1,000 SF of covered outdoor space.This close-knit community gathers regularly, where lifetime friendships are forged.' ,`Acres` = '0.2009' ,`Area` = '22' ,`BuilderName` = 'Built By Habitat' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 13A & 14 BLK 2 BRIARCROFT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '710' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Briarcroft' ,`TaxAmount` = '24472' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667412102' WHERE `Matrix_Unique_ID` = '213832704' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213836243','1667412103','213836243','2022-11-02T06:51:06.947','22402423','Gail Cain','Keller Williams Advtge Realty','','','30.412687','-95.664006','47','77356','13','775000.00','Active','Grand Pond','11746','Court','Montgomery','3','1','4','3501','Single-Family','Exquisite Stately Custom Home that will have you falling in LOVE! Situated on an oversized lot with a serene yard located in the highly sought after community of Grand Harbor on Lake Conroe. Your oasis awaits you, enjoy entertaining inside and out. 2022 NEW Roof and Gutters. This Gorgeous pool was installed 2021 with the Katch a Kid, Leaf cover, Grab bar. The Kitchen has Double Ovens, Island, Walk in Pantry. Solar screens in the front of the home, Upstairs you will discover a large game room, bedroom and full bath. Relax in your fully screened in back porch with built in grill and sink. Never worry about losing electricity with the Generac 38 Kw quiet cool Generator. The garage supports a 220 Volt Plug for a RV or Car Charger, separate 8 plugs on a 20 amp circuit by the garage sink. Grand Harbor is a gated community with amenities that include a private boat launch off Walden Rd.10 acre park with tennis, volleyball courts, baseball field, and pavilion.Check out all the amenities.','0.5603','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Lake Conroe Area','Central Gas','1','S538015 - GRAND HARBOR 15, BLOCK 1, LOT 18, ACRES 0.5603','Cleared,Greenbelt,Subdivision Lot,Water View,Wooded','24407','Appraisal District','','1200','0','','3','Double Oven,Gas Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Grand Harbor 15','9106','1.8242','Aerobic,Public Water','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213882246','1667412103','213882246','2022-11-02T06:34:41.710','89679101','Patrick King','Realty Kings Properties','','','29.902717','-95.455564','35','77038','11','294900.00','Active','Sweetshrub','11607','Lane','Houston','2','1','3','2542','Single-Family','Welcome to your beautiful new home in the desirable Westview Landing subdivision. On the main floor of this home you will find 9ft ceilings, a powder bath and stairs conveniently located by the entryway. As you move on, you will find the living-dining area with lots of windows allowing natural light to flood in and a beautiful open kitchen with granite countertops, 42-inch cabinets, black appliances, and ample center island. Steps away from the kitchen lies the full-size laundry room that can accommodate an extra freezer or can be used as a storage area. In addition, this level also offers a flex room w/walk-in closet that could be used as an additional bedroom, office, or for any number of purposes. Upstairs features a dreamy primary bedroom with walk-in closet and ensuite bath as well as two secondary bedrooms and large game room with separate area that can be used as study nook. Outside includes a spacious backyard and covered patio. Call today to schedule your tour.','0.1281','11','KB Homes','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Aldine Area','Central Gas','1','LT 5 BLK 1 WESTVIEW LANDING SEC 5','Subdivision Lot','5580','Appraisal District','','550','0','','2','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','CARTER ACADEMY','EISENHOWER HIGH SCHOOL','SHOTWELL MIDDLE SCHOOL','Appointment Required,Supra Keybox,Temporarily No Showings','Appraisal','2','Traditional','Westview Lndg Sec 5','8527','3.4553','Water District','2020','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:22:01.267' ,`MLSNumber` = '60591486' ,`ListAgentFullName` = 'Leobell Martinez' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.724704' ,`Longitude` = '-95.862876' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashton Meadows' ,`StreetNumber` = '28407' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the award winning community of Cross Creek Ranch, this stunning home with 5 bedrooms (2 down), 4.5 bath, game room, media room and Sparkling POOL with extended covered patio, including motorized modern Pergola is looking for a NEW owner. Entry to the grand foyer with high ceilings and home office enclosed with french doors. Wood looking tile and spectacular 2 story ceiling living space enhance with fireplace. Open floor plan with elegant white kitchen equipped with SS appliances, brand new gas cooktop and pendant lights over the island. Magnificent primary bedroom and bath with standing tub and huge walk in closet. Guest bedroom downstairs with in suite bath for convenience. Freshly painted and brand new carpet upstair beginning with an elegant staircase, big game room and media room for your next movie night. Exquisite outdoor living and convenient artificial grass in backyard, and 3 FULL car garage. Zoned to KatyISD schools:Campbell, Adams and Jordan.' ,`Acres` = '0.2347' ,`Area` = '36' ,`BuilderName` = 'Trendmaker/Tripointe' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK COVE AT CROSS CREEK RANCH SEC 10, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '18679' ,`TaxRate` = '3.3425' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412103' WHERE `Matrix_Unique_ID` = '213915822' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213944471','1667412103','213944471','2022-11-02T07:43:16.647','62267971','Susanna Mayberry','RE/MAX Leading Edge','','','29.305780','-94.784140','44','77550','5','599900.00','Active','Church','1503','Street','Galveston','2','1','2','1512','Single-Family','','0.1185','33','','','','','Sellers Disclosure','','','','East End','Central Electric,Zoned','0','ABST 628 M B MENARD SUR LOT 7 BLK 375 GALVESTON','Corner','5160','Appraisal District','','','0','','0','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','2','Traditional','Galveston Townsite','5034','2.0662','Public Sewer,Public Water','1928','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214044448','1667412103','214044448','2022-11-02T06:03:14.877','37333892','Haley Davalos','HomeSmart','','','29.742394','-95.507044','18','77063','9','1095000.00','Active','Burgoyne','7915','Road','Houston','2','0','4','2905','Single-Family','This beautiful and open floor plan four bedroom/two bath family home sits on an oversized 12,000 sqft. lot in the heart of Briarbend! Upon entry, you are welcomed with designer finishes, raised ceilings, LED lighting, and hardwood flooring. Standout features include a spacious kitchen with marble countertops and large island for entertaining, huge primary bedroom/bath addition with TWO primary walk-in closets, three secondary bedrooms with great closet space, sizable secondary bathroom with double sinks, and a massive, well-maintained back yard with a large, covered patio. Recent improvements (2020-2022) include new roof, new HVAC, exterior/interior painting, mosquito system, custom landscaping & lighting and Generac full-house generator! Owner/Agent','0.2775','22','','','Electric Dryer Connections,Washer Connections','','Exclusions,Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Charnwood/Briarbend','Central Electric','1','LT 3 BLK 2 BRIARBEND','Subdivision Lot','12090','Appraisal District','','490','0','','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Accompany,Appointment Required,Request Online Appointment','Appraisal District','1','Contemporary/Modern,Traditional','Briarbend','19241','2.3307','Public Sewer,Public Water','1960','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T06:31:37.363' ,`MLSNumber` = '45232170' ,`ListAgentFullName` = 'Traci Crawford' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822040' ,`Longitude` = '-94.990014' ,`PhotoCount` = '26' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Starling' ,`StreetNumber` = '8507' ,`StreetSuffix` = 'Court' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 4507 Starling Court! Located in the center of a cul-de-sac, this 2-story home offers a formal dining room or home office, 4 bedrooms, 3 and a half bathrooms, and media room. Inside you will find grand ceilings with open concept living areas, and large game room upstairs leading to balcony. The kitchen offers granite countertops, plenty of cabinet space, and large island. The home is wired with cameras and tv monitor that will convey with the property. Outside is an oversized patio that is perfect for entertaining and huge planters box ready for your touches and homegrown goods! Home is empty and carpets are clean and ready for you to call this one yours! Call to schedule your showing today!' ,`Acres` = '0.2055' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 GOOSE CREEK LANDING SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'PUMPHREY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'GOOSE CREEK LANDING' ,`TaxAmount` = '10111' ,`TaxRate` = '3.77' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412103' WHERE `Matrix_Unique_ID` = '214105579' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:43:06.790' ,`MLSNumber` = '31109057' ,`ListAgentFullName` = 'Austin Davis' ,`ListOfficeName` = 'Rogers Healy & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565142' ,`Longitude` = '-95.419227' ,`PhotoCount` = '45' ,`PostalCode` = '77584' ,`RoomCount` = '5' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Creek' ,`StreetNumber` = '12811' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2867' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready 2-story home built in 2006 nestled in the highly sought after Shadow Creek Ranch Community. This is one of the few 5 bed /3.5 bath homes at this price point! Beautiful exterior, high ceilings, cozy gas fireplace. Open concept floorplan joins main living to the spacious kitchen with granite counters, island, butlers pantry perfect for coffee bar. First-floor primary suite with dual vanities, jetted tub, and two spacious closets. Second floor is complete with 4 spacious bedrooms. One of which is a Mother-In-Law Suite with its own full bath. Come relax in your amazing backyard w/ covered patio and luscious grass. Close to community walking trails, pools, parks & splash pad. See this one first and make it your next home! Easy access to 288 tollway or Beltway, 20 minutes to Texas Medical Center and 22 Minutes to Downtown, nearby Pearland Town Center Mall, shopping, dining, and more!' ,`Acres` = '0.1635' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-38A (PEARLAND), BLOCK 4, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7122' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'YORK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '11119' ,`TaxRate` = '3.5409' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412103' WHERE `Matrix_Unique_ID` = '214162027' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214178138','1667412103','214178138','2022-11-02T07:48:41.420','97534166','Whitney Pugh','Legacy South Realty, LLC','','','29.348519','-95.281415','14','77511','7','275000.00','Active','Custom','6507','Drive','Alvin','2','0','3','1582','Single-Family','Welcome to 6507 Custom Drive! You will not want to miss this beautiful, updated 3 bedroom 2 bathroom home on .73 acres! This home has been updated so nicely and ready for it\'s new owners! Upon entering the front door, you will notice the tall, vaulted ceilings featuring dark-stained beams! Many updates include, all new cabinets in kitchen, beautiful quartz counter tops, and new stainless appliances! Throughout the common areas and primary bedroom, you will find wood-laminate and new carpet in the other two bedrooms! Other updates include, new interior doors, new hardware, updated lighting and plumbing fixtures! You will love this property\'s huge fenced-in back yard and 28X10 covered patio! Schedule your showing today!','0.73','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Alvin South','Central Electric','0','MARK V ESTATES (A0072 WM HARRIS (UNRECORDED)), LOT 56, ACRES','Subdivision Lot','31799','Appraisal District','','','0','','2','','0','','','Electric Range,Freestanding Range','','Composition','3 - Alvin','NELSON ELEMENTARY SCHOOL (ALVIN)','ALVIN HIGH SCHOOL','FAIRVIEW JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Mark V Estates','4649','2.2174','Septic Tank,Well','1981','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:52:30.270' ,`MLSNumber` = '92341767' ,`ListAgentFullName` = 'Brianna Sharum' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.737780' ,`Longitude` = '-95.548813' ,`PhotoCount` = '18' ,`PostalCode` = '77042' ,`RoomCount` = '6' ,`ListPrice` = '624900.00' ,`Status` = 'Active' ,`StreetName` = 'Locke' ,`StreetNumber` = '10006' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely, single story, 4 bed, 3 bath home in Briargrove Park just a short walk from shopping and restaurants! The home has granite countertops, travertine and hardwood floors, and a covered backyard seating area. The primary bedroom features two closets, and the fourth bedroom could also double as a game room. The neighborhood is quiet and secluded with peacocks roaming free. The Briargrove Park pool and tennis courts are only a couple of streets over from the house. The Galleria, Town and Country Shopping Center, Memorial City Mall, and Terry Hershey Park are within a few minutes’ drive.' ,`Acres` = '0.1809' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 & TR 41A BLK 2 BRIARGROVE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Briargrove Park Sec 01' ,`TaxAmount` = '12943' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412103' WHERE `Matrix_Unique_ID` = '214202692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:09:41.350' ,`MLSNumber` = '25921818' ,`ListAgentFullName` = 'Felipe Mendoza' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.486965' ,`Longitude` = '-95.207021' ,`PhotoCount` = '32' ,`PostalCode` = '77546' ,`RoomCount` = '10' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Mission' ,`StreetNumber` = '2007' ,`StreetSuffix` = 'Circle' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This 4 bedroom home with a POOL and zoned to Friendswood ISD is move-in ready! The home has 4 bedrooms, 2 full baths, and a half bath. The home has an office space, dinning room, a large kitchen with a breakfast bar that opens up to the breakfast area and oversized family room. There is plenty of natural light from the windows that over look the backyard which features a crystal blue Pool with Pergola and a firepit to enjoy those cool evenings. The upstairs of the home has the primary bedroom that offers plenty of space. There are double closets, double sinks, a garden tub and a shower, with vanity area. The detached 2-car garage is oversized and has additional space for storage or a workshop, including an additional overhead door. Recent improvements include fence, light fixtures, paint, and plumbing fixtures. Low HOA and No Back yard neighbors. This home has it all! Schedule your showing today and Welcome to Friendswood! (Owner/Agent)' ,`Acres` = '0.169' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 645 PAGE 2 LOT 22 BLK 1 MISSION ESTATES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '55' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Estates 3' ,`TaxAmount` = '7451' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412104' WHERE `Matrix_Unique_ID` = '214228272' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214237255','1667412104','214237255','2022-11-02T06:50:05.640','88891850','Felipe Mendoza','Entera Realty LLC','','','29.569933','-95.226103','27','77089','4','390000.00','Active','Five Iron','2102','Drive','Houston','2','1','4','2814','Single-Family','Immaculate Home in Green Tee Terrace! This 4 bedroom, 2 full and 1 half bathrooms home is move-in ready! The home sits on a corner lot in a Cul-De-Sac. As you walk into the home you are welcomed with high ceilings and beautiful arches. The elegant Formal Dinning room is very spacious and has wood floors. The Huge Kitchen has quartz countertops with white cabinets, a gas cooktop, and built-in oven and microwave. The kitchen also has a large walk-in pantry. The high breakfast bar overlooks the very spacious breakfast area and bonus space, which previously hosted a billiard table. A beautiful fireplace greets you in the spacious living room with plenty of room for the whole family. The primary bedroom continues with the high ceilings and engineered wood floors and easily accommodates large furniture. The Primary en-suite has a jetted tub, glass enclosed shower, two separate sinks, and a walk-around closet. This a well maintained home with plenty to offer. Schedule your showing today!','0.2275','3','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Southbelt/Ellington','Central Gas','1','LT 15 BLK 2 GREEN TEE TERRACE SEC 6','Corner,Cul-De-Sac,Subdivision Lot','9910','Appraisal District','','262','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','9 - Clear Creek','WEBER ELEMENTARY','CLEAR BROOK HIGH SCHOOL','WESTBROOK INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Green Tee Terrace Sec 06','6809','2.524','Public Sewer,Public Water','1998','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214239108','1667412104','214239108','2022-11-02T07:50:31.867','64715527','Jay Floyd','American Republic Realty','','','29.986047','-95.593150','36','77070','11','399000.00','Active','Primwood','11702','Drive','Houston','3','1','4','3705','Single-Family','Corner lot on cul de sac street. Both formals, Huge Den with high Cathedral ceiling with wood beams, built-ins and gas log fireplace. Kitchen features granite counters and travertine backsplash. Kitchen refrigerator, washer and dryer included. Study with built-ins. Bonus Room above the garage with full bath and separate entrance, can be apartment, game room or additional office space. 3 car garage, extended pool decking and mature trees. Fresh exterior paint. Per seller: one AC replaced 2015 and the other one replaced 2018.','0.2112','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Cypress North','Central Gas,Zoned','1','LT 33 BLK 11 LAKEWOOD FOREST SEC 1','Corner,Subdivision Lot','9200','Appraisal District','','690','0','','3','Electric Oven','1','Gunite','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS CREEK HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox','Appraisal District','2','Traditional','Lakewood Forest Sec 01','6682','2.3988','Public Sewer,Water District','1976','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214241201','1667412104','214241201','2022-11-02T06:54:09.027','86059736','Stephen Metarelis','Offerpad Brokerage, LLC','','','29.892443','-95.669341','13','77095','3','299900.00','Active','Pebble Run','7715','Court','Houston','2','0','3','2004','Single-Family','Charming single story in South Creek Village with so many updates on a cul de sac street. Two true bedrooms & a third room with built-ins in the closet area make this room a great flex room for your own custom needs. Light, bright, and an open floor plan with large windows. Luxury vinyl plank throughout all the main floors with new carpet in the bedrooms only. Living room has high ceilings and gas fireplace. Kitchen w/stainless steel appliances, and a newer high end Corian counter w/subway tile backsplash. Breakfast area w/bay windows for extra light and views to the nature setting yard. Hall bath w/new granite vanity, dual sinks & faucets. Backyard has extended patio areas and includes a raised decked, play space around a mature tree for young imaginations. Copperfield is a master planned community and offers many parks, pools, and great CFISD schools within the neighborhood. This home is also around the corner from the Langham Creek YMCA and is completely move-in ready.','0.1636','8','','','','','Mud,Sellers Disclosure','1','','1','Copperfield Area','Central Gas','1','LT 10 BLK 3 COPPERFIELD WESTCRK VLG 1 AMND','Cul-De-Sac,Subdivision Lot','7128','Appraisal District','','773','0','','2','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','LANGHAM CREEK HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Vacant/Unoccupied','Appraisal District','1','Traditional','Copperfield Westcreek Village','5851','2.471','Water District','1990','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T07:46:58.307' ,`MLSNumber` = '17559026' ,`ListAgentFullName` = 'Virginia Westbrooks' ,`ListOfficeName` = 'Darvita Mack Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.591123' ,`Longitude` = '-95.095721' ,`PhotoCount` = '19' ,`PostalCode` = '77058' ,`RoomCount` = '5' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Cornell Park court' ,`StreetNumber` = '3915' ,`StreetSuffix` = 'Court' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Precious patio home nestled in the quiet Clear Lake community of University Park. Very well kept home with three spacious bedrooms and two full baths. Living, dining, and kitchen areas offer a bright, open and inviting space for you to relax, dine, and entertain. Huge primary suite with primary bath that has separate tub and glass shower enclosure. Large soaking tub,Long double vanity, and a huge walk-in closet. Walk in closets in all bedrooms. The patio provides the perfect place to start your morning or sit and enjoy the sunset at the end of the day. Sprinkler systems in back and front yard. .LOW 2.54% tax rate, plus the convenience of an easy commuter route, excellent schools and UHCL nearby, Lawn maintained by HOA. NO HARVEY FLOODING! Convenient access to dining, shopping, parks, and more!' ,`Acres` = '0.1531' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 UNIVERSITY PARK PATIO HOMES 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BROOKWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'University Park Patio Homes 03' ,`TaxAmount` = '7478' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412104' WHERE `Matrix_Unique_ID` = '214252485' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214260149','1667412104','214260149','2022-11-02T06:49:17.140','77365209','Christopher Johnson','Texas United Realty','','','30.089367','-95.470306','11','77389','9','220000.00','Active','Nutwood','3626','Lane','Spring','2','1','3','2136','Single-Family','Welcome Investors or individuals looking for a house to renovate and call home. Located minutes from 45 north freeway. Come see this 2 story 3 bed 2 1/2 bath spacious home, in the very nice Forest North community. A Lovely floorplan with a decent size kitchen, formal dining area, kitchen/breakfast area, game room and massive master bedroom.','0.1524','14','','','','','Sellers Disclosure','0','Wood Burning Fireplace','1','Spring/Klein','Central Electric','1','LT 20 BLK 5 017*F5951900-003-005-020 FOREST NORTH SEC 3 R/P','Subdivision Lot','6640','Appraisal District','','380','0','','2','','0','','','','','Tile','32 - Klein','ZWINK ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','HILDEBRANDT INTERMEDIATE SCHOOL','Accompany,Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','2','Traditional','Forest North Sec 03 Rep','','3.024','Public Sewer','1998','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214282282','1667412104','214282282','2022-11-02T06:30:27.087','35086943','Dawn Hill','Coldwell Banker Realty','','','30.799778','-95.177625','36','77364','6','125000.00','Active','Monte Carlo','231','Road','Point Blank','1','0','3','840','Single-Family','Holiday Villages on Lake Livingston! This 3 bedroom, 1 bath mobile home is clean with a covered front porch and sits on 2 lots. It is being sold with the furniture and washer/dryer currently in the home. There is an RV carport with full hook-ups and a storage shed with an additional toilet and window unit. The property is completely fenced and gated. Community amenities include a clubhouse, swimming pool, boat launch, fishing pier, and a covered picnic area by the water. Visit their website for additional information regarding their upcoming events! Holiday Villages has a gated entrance and they are currently working on upgrading the roads in the neighborhood. This is one of the few neighborhoods around Lake Livingston with public sewer. Conveniently located within 30 minutes of Livingston or Huntsville. This property is a great weekend get-a-way, or the perfect landing spot for those who enjoy the RV life!','0.147','64','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','0','Lake Livingston Area','Central Electric','1','SILVER CREEK, SEC D OF HVL, LOT 56 & 57, HUD# TEN0663492, TI','Cleared,Subdivision Lot','6403','Appraisal District','','37','0','','0','Electric Oven','0','','','Electric Range','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Other Style','Silver Creek, Sec D Of Hvl','1104','1.6254','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214290315','1667412104','214290315','2022-11-02T07:07:02.077','4625361','Jose Gomez-Cheng','Lazo Realty','','','30.203704','-95.424298','47','77385','11','898500.00','Active','Southern Hawker','10410','','Conroe','4','1','4','4583','Single-Family','Gorgeous J Patrick 4 bedroom, 4 1/2 baths 3 Car Garage Home with Primary and Guest Room Down, 2 Bedrooms Up, also Study, Gameroom and Media Room - Designed and Custom Built to amaze their owners including draperies similar to those as on Model Home, a Luxury and Relaxing primary bathroom with whirpool tub and separate walking shower with dual shower head, and large walking closet. The beautiful and ample kitchen open to the large family room integrated with also great dining area which was ideally designed for entertaining and enjoying the whole family in one place! In addition this house came with an screened outdoor grill with side burner and sink on the back accessed from kitchen through high impact slide doors. In the other side there is a large outdoor interior living space with gas fireplace.','0.2238','15','J Patrick','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure,Tenant Occupied','1','Gaslog Fireplace','2','Spring Northeast','Central Gas,Zoned','1','S572704 - HARPER\'S PRESERVE 04, BLOCK 5, LOT 8','Cul-De-Sac,Subdivision Lot','9750','Appraisal District','','1304','0','','3','Electric Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','SUCHMA ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,No Photos/No Videos,Temporarily No Showings','Appraisal District','2','Traditional','Harpers Preserve 04','16600','3.1581','Water District','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214294078','1667412104','214294078','2022-11-02T07:57:18.197','41421498','Richard Aliperti','eXp Realty, LLC','','','29.788957','-95.530872','0','77055','6','350000.00','Active','Long Branch','9741','Lane','Houston','1','1','3','1310','Single-Family','This home is walking distance to Costco, HEB, Lowes and many Restaurants. Wonderful Spring Branch Schools. Memorial City Mall less than 1 mile away. Memorial Herman Hospital is less than 1 mile away also. Home is in need of TLC.','0.2134','24','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Spring Branch','No Heating','0','LT 2 BLK 2O LONG POINT WOODS SEC 3','Subdivision Lot','9295','Appraisal District','','','0','','1','Gas Oven','0','','','Gas Range','','Composition','49 - Spring Branch','WOODVIEW ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Contemporary/Modern','Long Point Woods Sec 03','6179','2.4415','Public Sewer,Public Water','1954','Appraisal District'); --> New record created successfully